Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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. 

 

 

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?

 

 

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

2 Replies

  • Cmcmahan's avatar
    Cmcmahan
    Resident Rockstar

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Wow. I feel dumb.

       

      Thanks.