Forum Discussion
Stop filtering of one visualisation
- 10 years ago
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.
PowerBIGuy I was originally thinking that when I posted my response but then wasn't sure if it would mean having to create a measure for each axis as well?
JasonDunbar just tested your suggestion, seems to work well on slicers so should allow filtering some visuals to defined years and others to show all years.
Thanks guys, I found a workaround. I created a reference table with distinct years, then created a many to one relationship between the tables. Next I create a measure for my variable with ALL('Distinct years') in the formula, and my filter for the page (i.e. the other viz that I want to change by year) is by the distinct years too. This somehow works!