Forum Discussion
Helper IIHow to make an interaction ignore a visualization-level filter
I got it!
Active Users = if(ISFILTERED(Table1[Building]), IF(CALCULATE(SUM(Table1[Active])) = BLANK(), CALCULATE(0, ALL(Table2[Room])), CALCULATE(SUM(Table1[Active]))), SUMX(FILTER(Table1, Table1[Active] > BLANK()),Table1[ActiveUserWithZero]))
Super UserTheMajesticKing can you send the pbix file. Remove any sensitive information before sharing it.
Helper IIHere's a link to the sample file
https://drive.google.com/file/d/1MEZAb7WoUGLUf-hjWC54T8XpF0HK46GK/view?usp=sharing
- parry2k
- TheMajesticKing
Yeah it's difficult to explain. Maybe I'll try to explain it in long form.
The visual that I want to manipulate is the bar graph (Active Staff By Room) on the right side of the report.
As you can see in your screenshot, there are rooms listed with zero active users. I don't want to see those rooms unless someone clicks on a building in the pie chart. When I click on a building in the pie chart (Active by Building) visual I want the Bar chart to show all of the rooms in that building regardless of whether or not it has 0 active users.
In other words I want to make it so the "Active Staff By Room" visual filters out the rooms with no active users when there is no active crossfiltering but then I want it to "unfilter" whenver a building is clicked in the "Active By Building Visual". I'll attach two screen shots to further explain what I want to see.
- parry2k
TheMajesticKing omg, you made is super complicated and it is very simple things to do, you just need to change the interaction between your center visual with right visual from cross highlight to cross filter.
- go to format tab
- click edit interactions
- select center visual
- on right visual, click filter icon instead of cross highlight and that will do it
I hope this is what you are looking for.