Single Option Slicer

[Anonymous]

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. 

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.

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

[Cmcmahan · Accepted solution]

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

[Anonymous]

Wow. I feel dumb.

Thanks.