Slicer should show only the items with data in the dashboard should appear in the filter.

[craghubi2020]

Could you please help me on this.

I have a cascading slicer "Product Model selector":

It should show only the products with data in the dashboard should appear in the filter.

[v-yingjl · Accepted solution]

Hi @craghubi2020 ,

You can create a measure like this, put it in the slicer visual filter and set its value as 1:

visual control = IF(SUM('Table'[Value]) <> BLANK(),1,0)

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.