Display all the selected filter items in the filter pane section on the report

[ksivaganesh99]

Hi all,

I want to display all the selected items which user selects in the filter pane sections on the report page.

Is there any way I can acheive it.

Any help is highly appreciated.

[BerryBIA]

the solution here is not correct as it is a solution for slicer values, not the fitler bar.

[v-xuding-msft]

Hi @ksivaganesh99 ,

For the answer of @Mariusz , does it make sense? If it works for you, please accept it as solution. If not, maybe you could reference the blog: Displaying filter context in Power BI Tooltips to have a try. It shows the filters that be applied at the report, page, and visual levels into tooltips.

[Mariusz · Accepted solution]

Hi @ksivaganesh99 

You can hover over or click on the funnel icon on every visual and it will show all filters applied.

As an option, you can create a Measure that will list all the selected values of a specific column, but you will have to specify every column that is in the filter pane, below you can see an example.

Selected Slicer Values = 
IF(
    ISFILTERED('Product'[Brand]),
    CONCATENATEX(
        VALUES('Product'[Brand]),
        'Product'[Brand], "; "
    ),
    "All Selected"
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn