Forum Discussion

TheMajesticKing's avatar
TheMajesticKing
Icon for Helper II rankHelper II
6 years ago
Solved

How to make an interaction ignore a visualization-level filter

I'm having a hard time trying to figure out how to explain what I'm trying to do but here goes: I have two visuals. A Campus "Map" visual and a "Room" visual. The Map visual shows a bunch of buildin...
Need Help
  • TheMajesticKing's avatar
    TheMajesticKing
    6 years ago

    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]))
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi TheMajesticKing , 

 

If you need to choose which visuals to be filtered by one special visual or not, then try to use "Edit interactions" feature, see more details: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions.

 

There is a similar case you can refer to : Table Filter Interactions .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • TheMajesticKing's avatar
    TheMajesticKing
    Icon for Helper II rankHelper II
    6 years ago

    I'm aware of how the visual filter buttons work. However, I'm trying to "Unfilter" the "Room" Visual whenever I click a building in the "Map" visual.