Forum Discussion
Toggle on / off Report Level filter?
The users of my report do not want to use the filter pane. All filters are displayed on the page.
I would like to somehow replicate a report level filter or have a toggle on the page that controls a report level filter.
The report level filter would be to exclude $0 transactions. I would ideally want a toggle on each page that can turn this on or off that carries through the rest of the report.
I can't think of a way this could be accomplished but I'm not sure if there are some creative solutions out there.
Anonymous , I doubt once you apply a report level filter you can toggle that.
Better create a toggle flag as column
if([Amount] = 0 || isblank([Amount]), 1, 0) and create a button and sync on all pages
Hi Anonymous ,
First thing I can think of is:
- You can create a small slicer with potential values like ON/OFF and syncronize it on all the report pages.
Thanks,
Pragati
2 Replies
- amitchandakSuper User
Anonymous , I doubt once you apply a report level filter you can toggle that.
Better create a toggle flag as column
if([Amount] = 0 || isblank([Amount]), 1, 0) and create a button and sync on all pages
- Pragati11Super User
Hi Anonymous ,
First thing I can think of is:
- You can create a small slicer with potential values like ON/OFF and syncronize it on all the report pages.
Thanks,
Pragati