topic Re: Add Button to Filter Based on a Column in Report Server

Add Button to Filter Based on a Column

LJL123 — Fri, 25 Jul 2025 11:53:18 GMT

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...

Re: Add Button to Filter Based on a Column

MasonMA — Fri, 25 Jul 2025 13:10:21 GMT

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:)

Re: Add Button to Filter Based on a Column

Nasif_Azam — Sat, 26 Jul 2025 16:36:17 GMT

Hey ,Bookmarks only store the state of visuals, including slicer selections, but can’t directly filter rows based on a column’s value unless paired with a slicer or another filtering mechanism. Try the following approach using a DAX measure and a button to toggle the filter:

Create a new table for filter control:

ActiveFilter = DATATABLE("Show Active Only", STRING, {{"Yes"}, {"All"}})

Create a slicer on your report using the ActiveFilter[Show Active Only] column.

Create a DAX measure to control visibility:

ShowRows = 
VAR SelectedValue = SELECTEDVALUE('ActiveFilter'[Show Active Only], "All")
RETURN
    IF(
        SelectedValue = "Yes" && 'YourTable'[Active] = "No",
        BLANK(),
        1
    )

Apply this measure as a visual-level filter to all visuals you want to control:
- Set the filter to "ShowRows is 1".

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam

Re: Add Button to Filter Based on a Column

v-pnaroju-msft — Mon, 28 Jul 2025 09:26:37 GMT

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.

Re: Add Button to Filter Based on a Column

v-pnaroju-msft — Thu, 31 Jul 2025 07:45:41 GMT

Hi LJL123,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

Re: Add Button to Filter Based on a Column

v-pnaroju-msft — Sun, 03 Aug 2025 16:07:32 GMT

Hi LJL123,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

Re: Add Button to Filter Based on a Column

v-pnaroju-msft — Wed, 06 Aug 2025 19:28:55 GMT

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.