Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 (WK_END_DT). There is one week end date for all days of a give week on the date table. I add (TOPN) to the (WK_END_DT) to filter down to only days in the current calandar week using (In_Current_Week) column. For each date in the date table it is either 1 or 0 for (In_Current_Week). 1 would me that the date is in the current week.
Page Filter
- I add (WK_END_DT) which shows me all options. Once I select one option.. the visual will adjust to my new page level filter selection... overriding the (TOPN) selection.. which is what I want. I just don't get why it is working that way. Any help here? Page level filters don't normally override visual level filters, correct?
Example Date Table Format
@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.