Forum Discussion
Stop filtering of one visualisation
The new update did bring this feature in. I just greated a report with a bar graph that does not filter with the page slices so that I could show multiple years across it instead of the single year I want to focus on in the other visuals. In the edit screen there is a new button on the ribbon called visual interactions. Click it then click the strike through circle on the visualization you want to keep from filtering. Very simple and it worked quickly.
Community ChampionThe new update did bring this feature in. I just greated a report with a bar graph that does not filter with the page slices so that I could show multiple years across it instead of the single year I want to focus on in the other visuals. In the edit screen there is a new button on the ribbon called visual interactions. Click it then click the strike through circle on the visualization you want to keep from filtering. Very simple and it worked quickly.
Hi
I was just wonder if this work on powerbi desktop version as I can only find that ribbon in the service version?
CheersSimon
NicholasHAdvocate I
Hi - On the desktop Power BI, Select the visual that is providing the filter (like a specific slicer), then in the Ribbon under "Visual Tools" there is a button for "Edit Interactions". After you click "Edit Interactions", on every other visual on the page you'll see some new icons in their upper right corners. On the visual you no longer want affected by this fiter, select the circle with the slash through it. Now that visual will no longer respond to your selected visual/slicer.
Thanks. You can also select specific slicers/filters to lock. For example if I have five slicers showing different attributes, I can allow four of them and leave only say the year locked.
