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]))
Helper IIHere's a link to the sample file
https://drive.google.com/file/d/1MEZAb7WoUGLUf-hjWC54T8XpF0HK46GK/view?usp=sharing
Super User- 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.
- parry2k
TheMajesticKing here is the post how it works
I would 💖 Kudos 🙂 if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
- TheMajesticKing
That's not what I'm asking. I'm already familiar with the filter button. That's what I used to generate the screenshot. Please read my previous reply entirely. I'm not just asking to filter out the zeros all the time. I want the zeros there when no data is being crossfiltered.
- parry2k
TheMajesticKing if your screenshot is showing zero room, what we are missing. I'm surely missing the point here.