how to hide slicer selection for which the visualizations have no data

[kaileena]

Hello

I have two slicers (Date and Entity) and a very sparce measurement table. I want to make unavaible the slicer combinations (let's say: Entity: Pib Date: Dec 2020) for which i have no measurements for.

Data exists for the selected slicer combination  (Entity: Customer Date: Feb 2022)

Data does NOT exists for the selected slicer combination ( Entity: Pib Date: Dec 2020).

So how can i hide the slicer combination for which my visualisations have no data (other than removing them all together from the slicer tables?) 

thank you very much

[v-yalanwu-msft · Accepted solution]

Hi, @kaileena ;

You could filter it.such as :

1.orginal .

2.select slicer then setting the filter.

The final show:

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

[Greg_Deckler]

@kaileena Create a measure that does a COUNTROWS of your fact table data. Add that as a visual filter on your slicer and set it to be not blank and greater than 0.

[kaileena]

Hello @Greg_Deckler ,

Thanks for your reply. 

Like this? what am i doin wrong?

regards,

kaileena

[Greg_Deckler]

@kaileena I think add an OR clause "Not blank" and change your greater than or equal to just greater than.