Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Okay so lets say I have the following dataset:
Then I create a bookmarks for a user that filters to Company A, B, and C and Filters to only show Action Required. In this example only Company B has any TXs in Action Required:
I want an "Active filters" pane so users can see which filters are set, especially when using bookmarks that were setup by other users, so I created the following Measure:
Active Filters - TX Table =
var line_break = unichar(10) & unichar(10) return
unichar(10)
& if(not(ISFILTERED(TX[Company]))&& not(ISFILTERED(TX[Status])), "All",
IF(NOT(ISFILTERED(TX[Company])),"",
"Company:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED(TX[Company] ),
TX[Company],
unichar(10) & "• ")
& line_break)
& IF(NOT(ISFILTERED(TX[Status])),"",
"Status:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED(TX[Status]),
TX[Status],
unichar(10) & "• ")
& line_break)
)
However, because of the cross-filtering when using ALLSELECTED() I will be missing items from the active filters pane if they do not have any data, so in this case Company A and C are missing from the active filters pane and i want them there:
I tried using parent tables instead for the report filters, and had my active filters measure point to those tables:
Active Filters - Parent Tables =
var line_break = unichar(10) & unichar(10) return
unichar(10)
& if(not(ISFILTERED(Company[Company]))&& not(ISFILTERED('Status'[Status])), "All",
IF(NOT(ISFILTERED(Company[Company])),"",
"Company:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED(Company[Company] ),
Company[Company],
unichar(10) & "• ")
& line_break)
& IF(NOT(ISFILTERED('Status'[Status])),"",
"Status:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED('Status'[Status]),
'Status'[Status],
unichar(10) & "• ")
& line_break)
)
This makes the active filters pane behave as I'd like however since Report filter pane is looking at the parent table, every value is 1 which I don't think I can live with:
Is there anyway to achieve what I'm after, either by changing the active filters measure or somehow manipulating the behavior or report filters?
I'm not sure I understand. You want them to be able to see what was filtered out?
My thoughts to simplify your solution:
Create a slicers for the filters and then create a table that is not linked to the slicer use the Slicer Interactions feature.
If you want them to be able to see all of the data, but only be able to manipulate the bookmarked view then give them view only access to the master table.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 36 | |
| 34 | |
| 31 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 103 | |
| 66 | |
| 65 | |
| 56 |