Forum Discussion
Impactful IndividualHide a value in table when selected in Slicer
Hello,
is it possbile to hide a value/ row in a table when I select it in a slicer? Thats practically the other way round. Normally I would see all numbers, instead through selection I let them disappear.
Best.
You can try using a DAX meausre with switch funtion, Inside your switch function for each slection in slicer apply a filter for the data that you don't want to show.
Some thing like this
Measure = SWITCH
(
Var Slicer_Selection = Seletedvalue('Table'[Column Name], 0)
Return
Slicer_Selection = 'Slicer Selecetion1', Filter('Table'[Column Name] <> 'Slicer Slection1'
Slicer_Selection = 'Slicer Selecetion2', Filter('Table'[Column Name] <> 'Slicer Slection2'
)
1 Reply
You can try using a DAX meausre with switch funtion, Inside your switch function for each slection in slicer apply a filter for the data that you don't want to show.
Some thing like this
Measure = SWITCH
(
Var Slicer_Selection = Seletedvalue('Table'[Column Name], 0)
Return
Slicer_Selection = 'Slicer Selecetion1', Filter('Table'[Column Name] <> 'Slicer Slection1'
Slicer_Selection = 'Slicer Selecetion2', Filter('Table'[Column Name] <> 'Slicer Slection2'
)