Slicer filtered value

[sabeensp]

Hello,

I have a slicer on Color, is there a way to only show those colors, where values are in rest of teh columns, if any of the column does not have value I do not want to show in the slicer.

Color ------- Col 2 ------ Col2 -------- Col3
Red      ------- X      ------- X        ------- X

Blue     -------         ------- X        ------- X
White   ------- X      ------- X        ------- X
Green   ------- X      ------- X        ------- X
Brown  ------- X      ------- X        ------- 
Pink       -------         ------- X        ------- X

I only want Red, White, and Green to show in the slicer, becasue those are the only 3 colors, we have values in the other 3 columns.

Thanks

[Greg_Deckler · Accepted solution]

For whatever reason, slicers do not support visual level filters. You could use page or report filters to filter these out, or you could simply do something like this:

Column = SWITCH(TRUE(),
    ISBLANK([Col1]) || ISBLANK([Col2]) || ISBLANK([Col3]), BLANK(),
    1
)

And then:

SlicerTable = DISTINCT(SELECTCOLUMNS(FILTER('Table8 2',[Column]=1),"Color",[Color]))

Relate this table to your other table in the obvious way. Use it as your slicer instead.