Forum Discussion

LJL123's avatar
LJL123
New Member
1 year ago
Solved

Add Button to Filter Based on a Column

I want to add a button to my report that will filter out any rows on the report where the column titled "Active" = "No." How can I do this? I've tried with bookmarks but it doesn't seem to work...
"Filters"
Bookmarking
Button
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Thankyou, MasonMA, Nasif_Azam, for your response.

    Hi LJL123,

    We appreciate your query posted on the Microsoft Fabric Community Forum.

    Based on my understanding of the issue, please find attached screenshots and a sample PBIX file demonstrating the use of bookmark based buttons to toggle a slicer filter that hides rows where the Active column is set to “No.” We have utilized two buttons with bookmarks to toggle the slicer selection on the Active column for “Yes” and “All,” which dynamically show or hide rows according to the user’s selection.

    We hope that the information provided will help resolve the issue. Should you have any further questions, please do not hesitate to reach out to the Microsoft Fabric Community.

    Thank you.

    Button_to_a_filter.pbix29 KB
MasonMA's avatar
MasonMA
Super User
1 year ago

Hi LJL123 

 

Not sure if I understand your question 100%, did you mean you have column/field in a table whose name is "Active" as in below picture and you would want to add button to filter out the rows that are 'No'?

If this is what you are looking for, consider using 'Button Slicer'.

Hope this helps:)