Awesome, Thanks Reza, Right to the point I had spent over a day trying to figure this out and the solution you provided was very concise and right to the point.
Hi, thanks for your tutorial. I have a similar situation but I have also a date slicer. How can I make this work taking into account also a data range period? For example if a customer has a net amount in a range of time and not in another, how can I hide him when he has no amount?
Thanks for the great video! But there seems to be a bug, that is when you change the fullname slicer, the selected value of product name slicer will not change until you manually change it. Is there any way for a walkaround?
Thanks for the solution... it does its purpose. I have some questions: can I use the bi-directional cross--filter in any relationship? like 1:* or *:*; Wouldn't this impact the performance of the dashboards? Or is it something that happens if the dashboard and the dataset are huge?
Thanks for the great tip. Can you please also make a video for date range slicer selection, so i have company name slicer and date range slicer and I want to start the date when the selected company signed up, how can I do that? I have multiple companies with different sign up date and i have to use date range slicer
Want to know why have you created sum measure like this ? If suppose we are not having sales column in our table rather than we have some dimension table column with customer name and product how can we achieve the slicer filtering?
With this method, you show the possible options in the 2nd slicer. Is there also an option, when I select an option in slicer 1, also 1 option is selected in slicer 2?
If i have 2 fact tables connected to 1 dimension table, then do i need to create 2 measures one on each fact table and add those 2 measures on Dim slicer filter?
Hello, How to select only one option in two different filters? example: In Filttro 1 it has the options (A, B ,C) and in Filttro 2 it has the options (D,E,F). So, how to select only 1 option among all options (A,B,C,D,E,F)?
@@adolfojsocorro yes. Because it is filtered to show values only when there is a value in the fact table. If you take our the visual level filter, then slicer shows all available values in the dimension anyway.
It's work..I have variance column where I have created Dax .Hence selected criateria not blank cell .it's work while on the session once I re open BI dash..the filter is not working...can you please help
this is an excellent solution, have a quick question related to this, i have a state dimension and product dimension . One slicer belongs to state and another slicer belongs to product. Based on these two slicers the who visuals are interacting with the report. How should i write a measure for those dimensions ?
That might need a both-directional relationship which is not recommended. another way is to use drill through to another page with the selection of slicers
Cool ! But it is not working when the slicer (over a data with int type) has a "Between", "less than" or "greater than" ascpect. In the dropdown and list aspect it is working fine... Do you know if it's some bug?
its not working when you have a blank.. When a filter contains blank also with other categories, all the other categories are hidden and the filter shows only blank. Please Help!!!!
@@RADACAD Any article ? Can you please post link here ?? :) I have 7 slicers 9 Fact 200 Measures in my model, I was trying to this bi-directional but it is working for One Fact Table, While the same dimension connecting with another fact it will automatically create inactive , Oops :( i cant re-write all the measures by using USERELATIONSHIP, Could you please suggest the way to solve it
Hi Team, i am watching your videos, thanks for sharing the same, i have a query - hope you could solve the same for me... Query : two different slicers on Country, Measure 1 = Sales value in Country A (from Slicer 1), Measure 2 = Sales value in Country B (from Slicer 2) , Measure 3 = Variance between Measure 1 & 2, but i am not getting the correct output, can you please help me to fix it. Thanks
Such a simple solution. Thank you. I spent last 4 hours trying to write complicated solutions to problem that I've created.
Awesome simple solution. Works like a charm!
Glad it helped
Simple and exactly what I needed. Thanks!
I am searched a lot for this and dropped but now i am happy thank you....
Thank you so much for clarifying this concept! You saved my report!
This is the solution I've been looking for for several days. Thank you very much!
Could not appreciate more. Thank you so much
Happy to help!
Great. Have been looking at several solutions avoiding two-way filtering in the relation. This is the best and simple solution. Thanks.
This worked perfectly - thank you!
Awesome, Thanks Reza,
Right to the point
I had spent over a day trying to figure this out and the solution you provided was very concise and right to the point.
You're welcome!
Thank you! I was looking for something like that.
thanksss man you're awesome. love the simple idea but very impactful!!!
Yes, exactly what I needed. Thanks
This helped me today. Thank you!
Thank you for sharing this!
I was looking for this thank you very much
Great stuff sir! Thank you!
thank you very much for this video. It is perfectly working for me 🙂
Perfect! Thank you!
Thank you, thank you, thank you.
Hi, thanks for your tutorial. I have a similar situation but I have also a date slicer. How can I make this work taking into account also a data range period? For example if a customer has a net amount in a range of time and not in another, how can I hide him when he has no amount?
It helped me a lot......
Thank you, really awesome
Superb, this is really useful thank you.
That's awesome, thank you
Worked. Thank you.
Glad it helped
Thank you man saved me :)
Thanks for the great video! But there seems to be a bug, that is when you change the fullname slicer, the selected value of product name slicer will not change until you manually change it. Is there any way for a walkaround?
I have the same issue. Would love a solution!
Thank you so much !! :)
Great thank you.
Just curious - why this can't be the default behaviour for all visuals?
THANK YOU! 👍👍👍
Thanks for the solution... it does its purpose. I have some questions: can I use the bi-directional cross--filter in any relationship? like 1:* or *:*; Wouldn't this impact the performance of the dashboards? Or is it something that happens if the dashboard and the dataset are huge?
BI directional relationship impacts the performance even for small datasets, not recommended at all.
Great, very helpful
Thanks for this.. is there anyway to do this with the native filter pane?
Thanks for the great tip. Can you please also make a video for date range slicer selection, so i have company name slicer and date range slicer and I want to start the date when the selected company signed up, how can I do that? I have multiple companies with different sign up date and i have to use date range slicer
Hi, I have the same problem, have you found a solution?
@@Hydrarian Yes i have got but not a best solution I have selected cross filtration in both ways
@Radacad I want to see full list of english Product name and don't want to filter it. How can i do so?
This is absolutely fantastic. However I had no option but to use bi-directional option in my report and is working fairly well
Want to know why have you created sum measure like this ? If suppose we are not having sales column in our table rather than we have some dimension table column with customer name and product how can we achieve the slicer filtering?
With this method, you show the possible options in the 2nd slicer. Is there also an option, when I select an option in slicer 1, also 1 option is selected in slicer 2?
If i have 2 fact tables connected to 1 dimension table, then do i need to create 2 measures one on each fact table and add those 2 measures on Dim slicer filter?
Hello, How to select only one option in two different filters? example: In Filttro 1 it has the options (A, B ,C) and in Filttro 2 it has the options (D,E,F). So, how to select only 1 option among all options (A,B,C,D,E,F)?
Cool technique, with the consequence that the slicers will show only values present in the fact table.
Yes. That is the point of this trick. Otherwise no visual level is needed.
@@RADACAD I mean, when nothing is selected anywhere the slicers show only existing values, not all values in the dimensions.
@@adolfojsocorro yes. Because it is filtered to show values only when there is a value in the fact table. If you take our the visual level filter, then slicer shows all available values in the dimension anyway.
What if there are no measures used,what can be alternative way
Why did yo use calculate in the measure? It works the same as a simple sum.
My filter screen is not like yours and I have the latest June 2021. I can't get your solution to work. I like it--but it won't work for me.
"One Slicer to filter them all" 💍
It's work..I have variance column where I have created Dax .Hence selected criateria not blank cell .it's work while on the session once I re open BI dash..the filter is not working...can you please help
this is an excellent solution, have a quick question related to this, i have a state dimension and product dimension . One slicer belongs to state and another slicer belongs to product. Based on these two slicers the who visuals are interacting with the report. How should i write a measure for those dimensions ?
If my sales have negative and blank value then how to write condition
Great article. Do you know if could be possible filter both slices based on a selection in the Table visual?
That might need a both-directional relationship which is not recommended. another way is to use drill through to another page with the selection of slicers
what if there are more than one measures ??
Cool ! But it is not working when the slicer (over a data with int type) has a "Between", "less than" or "greater than" ascpect. In the dropdown and list aspect it is working fine... Do you know if it's some bug?
Hi, I have the same problem, have you found a solution?
its not working when you have a blank..
When a filter contains blank also with other categories, all the other categories are hidden and the filter shows only blank.
Please Help!!!!
Will this work for Select all option for second filter?
I like it, but now you can never see the full list of products right?
can we replicate the table selection to slicer?
How would you do this for a report where you have multiple fact tables and multiple dimension tables with relationship to the fact tables?
There were different workarounds for that. calculated tables with subset of data was one of the methods previously I have used.
@@RADACAD Any article ? Can you please post link here ?? :)
I have 7 slicers 9 Fact 200 Measures in my model, I was trying to this bi-directional but it is working for One Fact Table, While the same dimension connecting with another fact it will automatically create inactive , Oops :( i cant re-write all the measures by using USERELATIONSHIP, Could you please suggest the way to solve it
Hi Team, i am watching your videos, thanks for sharing the same, i have a query - hope you could solve the same for me...
Query : two different slicers on Country, Measure 1 = Sales value in Country A (from Slicer 1), Measure 2 = Sales value in Country B (from Slicer 2) , Measure 3 = Variance between Measure 1 & 2, but i am not getting the correct output, can you please help me to fix it. Thanks
Hello. Do you know how the connect powerbi to Google sheets and have a strong connection in which refresh doesn't have errors.
I haven't used Google Sheets as a source, but there is definitely an issue that causes errors. what connection type you used?
Thank You, Can you please share the link to download the database and try to check from our end.
Here is the link: radacad.com/files/AdventureWorksDW2012.xlsx
Will it works for Snowflake schema...?
How were you handling such situations when you could not add filters to slicers?
One of the methods was to use a calculated table with a subset of data. I have written a blog article about it previously.
Wheres the download?