Forum Discussion
Why Does Page Level Filter Override Visual Filter When Using TOPN?
I am not quite sure how (TOPN) works in my situation. Page level filter seems to be overriding (TOPN) visual filter.. why is this? Visual filter - I am filtering by the date table column called ...
beau4powerbi Think of it like a hierarchy:
Report Filters
- Report Page Filters
- Visual Filters
It's just how it works. You can override the filters using DAX in many cases.
I did test this situation (that I think describes your above description) and it does not work the same.
Say your visual displays sum of sales by state (ex. Michigan = MI) and you have sales for every state. You put a filter on that visal for state = MI. So now you are only seeing MI and the sales total. But if you then put a state filter at the page level.. and choose CA for califonia.. it will not override MI to show CA on the visual.. the visal will show blank.