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.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Hi LJL123,

We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.

Thank you.