Use Slicer but gray out not available values

[04diiguyi]

 I have a table, and add multiple slicers to filter out the table data.

Currently I can choose one or multiple slicers to filtered out the table and other slicers.

However, one of the slicers is special, I do not want to filter out the data, I want to gray out the values do not exist, still keep all the values, allow multiple selections and etc. So that when I use other slicers, I know what values are available/unavailable in this slicer.

Is this doable?

[v-nuoc-msft]

Hi @04diiguyi 

@parry2k Thank you very much for your prompt reply. Allow me to add something here.

The slicer should be used as a source of screening, not as a result of screening.

Therefore, you cannot filter another slicer by another slicer.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@04diiguyi unfortunately it is not possible, you cannot make values unavailable while listed in the slicer.