Chiclet slicer blank data

[erhan_79]

Dear All ;

İ created chiclet slicer visiual but on this visual "Blank" data is comint too.How can i delete in this slicer that blank data , i just want that  filter "16" seem.

thanks

[v-cherch-msft · Accepted solution]

Hi @erhan_79

The first way: Add a page level filter to set the column is not blank.But it might effect the whole report data.

The second way: Add a hidden slicer which is used to filter the visible one.You may refer to this video.

Regards,

Cherie

[erhan_79]

thanks @v-cherch-msft , i solved the problem

[PattemManohar]

@erhan_79 Please try to create a calculated table with the field that needs to be used in the slicer along with the Key column. Use this key column to make a relationship with the main table. 

Test164Out = FILTER(Test164,NOT(Test164[Data]=BLANK()))