Hide items with no data in PowerBI's slicers ?

[ZeBotch]

Hi,

How can i hide (or visually indicate) items with no data in PowerBI's slicers, like in Excel with the Slicers Settings Frame ?

Thanks !

[Adamtall · Accepted solution]

Hi,

try to make a column

Spoiler

dont show = if('Table'[value] <> BLANK() ; 'Table'[Column1];BLANK() )

then drag that column to the slicer.

or you can add a filter on the visual-

/Adam

[ZeBotch]

It works by simply inserting a filter with the correct item directly into each slicer.

Thanks Adam !