single select
1 TopicSinge Select Slicer with Select All
I have a large data table with a column that returns two values based on an IF statement. IF true THEN "Default" ELSE "Not Default" What I would like to do is to create a slicer that on a single click: Filters to all "Default" values Return all values are returned that are both "Default" AND "Not Default" I've been playing around with Switch and IF functions and am not able to figure this one out. Any help is appreciated!Solved1KViews0likes4Comments