Forum Discussion
Create Slicer that removes a filter
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.
Super UserI 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.
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!
