Pivot Table Slicers - Only Display Items with values?

[Caleeco]

Hello,

I'm not sure if this is possible in Excel, but I would find it very useful if it is!

When using multiple slicers, often you'll end up with greyed out slicer buttons where data isnt available for the current filtered data.

Is there a way to prevent these 'greyed out' options from even appearing in the slicer (given they are not available to select). So in the example below, only Canada, Italy & USA would appear in the slicer box.

Any guidance would be appreciated
Thanks
Caleeco

 

[Caleeco]

aha! I'm such a fool... just found it!

Right Click > Slicer Settings > Hide Items with No Data