Exclude Slicer value if it does not have metric data.

[akj2784]

Hi,

I have a slicer with Department Name and a waterfall chart with Category and a Headcount.

I want to exclude those Department Name from the slicer which has headcount as 0.

Regards,

[v-shex-msft]

HI @akj2784,

Maybe you can drag depart column to page level filter and filter value who equal to zero.(slicer not support visual level filter)

Regards,

Xiaoxin Sheng

[akj2784]

That does not help. I want to exclude those department which doesnt have any headcount. 

[v-shex-msft]

HI @akj2784,

Can you provide some sample data for test?

Regards,

XIaoxin Sheng

[akj2784]

I dont see the option to upload pbix file.

[akj2784]

Something like this. I want to exclude C from Type slicer as I don't have any data for this type in the fact. 

[v-shex-msft]

HI @akj2784,

No, current slicer not contains this feature, I'd like to suggest you post this requirement to idea forum.

Regards,

Xiaoxin Sheng