Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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.
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |