Forum Discussion
Helper IIDisplay all the selected filter items in the filter pane section on the report
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.
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
3 Replies
- Mariusz
Community Champion
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 
v-xuding-msftCommunity Support
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.
BerryBIAAdvocate I
the solution here is not correct as it is a solution for slicer values, not the fitler bar.