Forum Discussion
Remove a page filter from a table
On a table of multiple columns, three columns form a hierarchical relationship:
Award Code (example: 505115)
Major Class code (example: 12XX)
Class Code (example: 1230)
There are three more columns: budget, actuals, and available budget (shown above).
On the second page of report, drill through is enabled and there are page filters:
Award Code
Major Class Code
Class Code
On this page, there is a table. If I click 1230 (red underline) on the first page of report and drill through to the second page, this is how the table looks like:
It is easy to see that this visual has three filters:
How can I remove the Class Code filter from this table, so that it displays all Class Codes under a given Major Class Code. Using the above example, this is what I would like to have for the table:
3 Replies
Thanks for your input. I thought about it too. There are a few other visuals on the same destination too, and page-level filters are a simpler setup.
Hi Curious1_209 ,
Would you consider creating three measures for the three Values fields circled in red in the figure below to replace the original value fields and adding filtering criteria: REMOVEFILTERS('Table'[Class Code])?
Best Regards
