Forum Discussion
Conditional filtering based on specific row value, with several dashboards
Hello
I have a list of countries and then there is a special "all" also included, which is made for one specific visual, to show the overall value.
Other visuals in the dashboard don't have "all" included into their country tables. If I select 'All' then other dashboards will be empty and the only one that uses "All" shows data. IF no country is selected then other visuals will show what they should but the one that needs all shows wrong data. I don't want to delete the interaction between the visuals, I need some type of a conditional filtering, but haven’t figured it out.
All tables are connected to country table, which is an extra table and includes "All".
Would really appreciate any type of help.
What i need is that when nothing is selected, then special visual which requiers "all" is selected and when all is selected other visuals will act like nothing is selected.
Hello Xiaoxin,
Thank you for you effort!
I found a way to work around it, it is not perfect but looks like that.Measure = if(iscrossfiltered([averageAge]),FIRSTNONBLANK(age[averageAge],
[averageAge]),CALCULATE(FIRSTNONBLANK(age[averageAge],[averageAge]), FILTER(age,[country] = "All")))
I hidde "all" from slicer view, so when nothing is selected then the averageage is 39 and the unit is what it should be and if a country is selected then numbers will be correct.
Thank you again for your effort!
Kaarel
8 Replies
vannipart be really helpful here if you could provide some screen shots. visuals give better understanding
Here are three situations situations, that i have.Hi vannipart,
Can you please share a sample pbix file to test? Based on your screenshot, it is hard to reproduce your issue.
Regards,
Xiaoxin Sheng
Hello,
I made an example table. So the right combinationm, when slicer nothing is selected would be age=39 and unti 19872873 and if all is selected then age should be 39 and 19872873. Of course by chaning country the numbers will go in an correct way.
https://pictureskk.blob.core.windows.net/pic2/EXAMPLEALL.pbix
Best of luck,
Kaarel
