Forum Discussion

sartys's avatar
sartys
Frequent Visitor
6 years ago

Ignoring static filter when applying visual filters

Hi,

Is there any way to ignore "static" filters from filters pane when applying visual filters.

I have a report like this, where I show data for two years (blue - 2020, red - 2019)

 

The highlighted table has data for Fiscal Year 2020, filtered on Filters Pane. 

 

Now when I try to filter this page visually by selecting one of the cost centres in the table, PowerBI applies also Fiscal Year filter, resulting in Blanks in 2019 / red cards. Is there any way to ignore "static" filters when I use visual filters?

 

Need Help

2 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi sartys , 

    It seems that you want to ignore page filter when you use visual filter, right? I think you could try  to remove Report / Page level filter from report filter pane.Then put those filter to Report page, select the value & chose edit interactions to deselect visuals where you don't want to apply the filters to see whether it work or not

    Best Regards,
    Zoe Zhi

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

     

    • sartys's avatar
      sartys
      Frequent Visitor
      6 years ago

      Hi dax .

      No, I want to ignore visualization filter or more precisely to not transfer static visualization filter from one element to another, but keep dynamic/selection filter