Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
NenaG
New Member

Create Slicer that removes a filter

I have field "STATUS" and I need my report page to include by default all records except where value of STATUS is "bad". But I need to provide a way for users to be able to click something to include "bad" (slicer, button, etc; the type of visual isn't important). I know how to create a slicer for "Exclude (value)" but I can't for the life of me figure out how to do it the other way around. Can anyone help?

 

Example:

Default showing in report:

NenaG_2-1748626577172.png

 

After toggle is selected:

NenaG_3-1748626629731.png

 

 

 

 

 

1 ACCEPTED SOLUTION
ToddChitt
Super User
Super User

I kicked a game-winning goal, then you moved the goal posts on me 🙂

I thought about this suggestion first, but rejected it for Bookmarks, thinking the latter would be easier.

Do you have a dimension table for Status? If not, create one. Then in there, create a CALCULATED COLUMN that is something like this:

Is Bad = IF ( [Status] = "Bad", "Yes", "No" )

and use that in the slicer. Maybe even create a two-field slicer with this one first.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





View solution in original post

4 REPLIES 4
ToddChitt
Super User
Super User

I kicked a game-winning goal, then you moved the goal posts on me 🙂

I thought about this suggestion first, but rejected it for Bookmarks, thinking the latter would be easier.

Do you have a dimension table for Status? If not, create one. Then in there, create a CALCULATED COLUMN that is something like this:

Is Bad = IF ( [Status] = "Bad", "Yes", "No" )

and use that in the slicer. Maybe even create a two-field slicer with this one first.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





I think the two-field slicer is the way I'm going to have to go with this one. Thank you for the help, and sorry about moving the goal posts on you! 

ToddChitt
Super User
Super User

I suggest you investigate Bookmarks in Power BI Desktop. And also learn how to activate them via a Button. With a Bookmark, you can first set the value(s) of your various slicer(s) then 'put a stake in the ground' with the Bookmark. With a button activating said Bookmark, users can get to a consistent state every single time with one click.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





This is a good solution based on the information I shared, but there are details that I didn't include that make it not quite work. There is an existing slicer on the page for "Select User", and when I save a bookmark it also saves the selected user since bookmarks capture the state of the entire page. I need a way for my users to make a selection and toggle back and forth between "all except bad" and "all including bad".

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors