Forum Discussion
Helper IIICan a button clear a single filter?
When a user selects a data point, I would like to show a button that indicates the filter being used. When the button is clicked, the filter would be removed and the button would disappear. The image below shows what I'm trying to accomplish. Is this possible? I know I can use a bookmark to clear all filters, but I want to be able to clear them one at a time.
Hi Kimber ,
Bookmarks are a transient state in Power BI Desktop and we can use bookmarks to store the state we need. Single deselection can optionally be linked with a button and a bookmark, so that a single deselected transient state can be realized. I think you can check this documentation on bookmarks: Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you SO much!!!
6 Replies
- Sergii24
Super User
Hi Kimber, you can achieve it by using a measure. In the measure you capture filter values and then display the measure in a text box. See example below:
Label Filter Column1= IF( NOT( ISFILTERED('Table'[Column1]) ), //if nothing is selected "All", //then show this (you can replace it with blank) CONCATENATEX( //otherwise (so the column is filtered) VALUES( 'Table'[Column1) ), //get current values [Column1], //access the temporary column with the data ", " //concatenate values from above (makes sence if you have few values) using "," delimiter ) )You can create multiple measures or combine multiple values within the same measure (as you preffer 🙂 )
