Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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"
)
the solution here is not correct as it is a solution for slicer values, not the fitler bar.
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.
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"
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |