Slicer to only filter on TRUE

[joshua1990]

Hi all!

I have a report with a table visual that displays the actual sales etc per department.

There are also some binary columns (TRUE / FALSE) based on specific rules.

Now I would like to add some buttons or slicers on top but only with 1 icon for each button.

If I click on that button I would like to only see the values that are filtered for TRUE for that specific button.

Is this possible in Power BI? 

[Kedar_Pande]

@joshua1990 

1. Create a disconnected table with the binary flags (e.g., "Filter A", "Filter B").
2. Use a slicer or button (with icons) based on this table.
3. ShowRows =
   SWITCH(
   SELECTEDVALUE(FilterTable[Filter]),
   "Filter A", IF(YourTable[FlagA] = TRUE(), 1, 0),
   "Filter B", IF(YourTable[FlagB] = TRUE(), 1, 0),
   1
   )
4. Add a visual-level filter to your table visual: ShowRows = 1.

[mark_endicott]

@joshua1990 - A slicer will give you the option to select from the values of TRUE or FALSE from a dropdown or list. You could place a filter on the slicer to only show the TRUE option, but you will not then ever be able to select FALSE or see these values.

If you would rather just have a button that shows the TRUE values, you can acheive this through Bookmarks (and a button).

It will be quite a complex process to set this up according to your specification, so heres the official documentation first: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks

And here's a step by step:

📝 Step-by-Step Instructions

1. Apply the Filter

1. Go to the visual you want to filter.

2. In the Filters pane (right-hand side), locate the field/column you want to filter (e.g., IsActive).

3. Drag it into the Visual-level filters section.

4. Set the filter condition to show only when the value is TRUE (or 1, if it’s a Boolean column).

5. Confirm that the visual updates correctly to reflect this filter.

---

2. Create the Bookmark

1. Go to the View tab and make sure the Bookmarks pane is open.

2. Click Add to create a new bookmark.

3. Rename the bookmark to something meaningful, like "Show Active Only".

4. Right-click the bookmark and ensure the following options are selected:

   • ✅ Data – to capture the filter state.

   • ✅ Display – if visuals are shown/hidden as part of the change.

   • ✅ Current Page – if you're using page-specific filtering.

5. This bookmark now saves the filtered state of the report. To do this select "Update"

---

3. Add the Button

1. Go to the Insert tab, and select Buttons → Blank (or a style like Left Arrow or Text).

2. Position the button on the report where you want it.

3. With the button selected, open the Visualizations pane and under Action:

   • Turn Action to On.

   • Set Type to Bookmark.

   • Set Bookmark to "Show Active Only" (or whatever you named it).

---

4. (Optional) Add a Reset Button

If you want users to toggle back to the unfiltered view:

1. Remove the filter from the visual.

2. Create a second bookmark, e.g., "Show All".

3. Add a second button and assign it the "Show All" bookmark.

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!