cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sethwallin
Helper I
Helper I

Single Option Slicer

I have two different amount columns, one for cleared, one for discrepant, and I want to create a slicer to show only the records with a discrepant amount. Most of the time it's an either/or scenario, but there is a small population that has values for both.

 

I tried using a calculated column as a helper to drive the slicer, but then if you select the "No" option, it will remove the last line and give the wrong total for the "Cleared" column. 

 

Capture.PNG

 

And if I change the "No" to being blank, then the slicer has the "(Blank)" option, which I'd prefer not to have so as not to confuse end users.

Capture2.PNG

 

Ideally, the slicer would look more like this, being closer to a toggle. Is that even possible?

Capture3.PNG

 

 

1 ACCEPTED SOLUTION
Cmcmahan
Resident Rockstar
Resident Rockstar

Sure.  Edit the visual level filter on your slicer, and set it so that it only displays values where [Discrepant?] = "Yes" 

View solution in original post

2 REPLIES 2
Cmcmahan
Resident Rockstar
Resident Rockstar

Sure.  Edit the visual level filter on your slicer, and set it so that it only displays values where [Discrepant?] = "Yes" 

View solution in original post

Wow. I feel dumb.

 

Thanks.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors