What does it mean in table slicer settings to hide items with no data?

What does it mean in table slicer settings to hide items with no data?

Why would there be items with no data there? I have a table that to me obviously has items for the filter DJUDJR0, but the slicer still hides it if I set the slicer setting to hide items with no data

SNAG-0001.png

Hi OldManExellor,

It will hide filter options that are no longer relevant if another slicer filter is selected. For example, for a table with city information you have continents and countries as slicers. Once you click Europe, it will hide all Asian countries, instead of greying them out.

In your example (blank) is still a relevant filter option.

I hope this makes sense.

Slicer hidden
Slicer hide.jpg

Slicer not hidden
Slicer no hide.jpg

Thank you for your answers. You confirm how I thought slicers should work.

But in my screen shot Excel thinks that DJUDJR0 is empty although obvioulsy that filter has no data, as you can see the rows in the table of the screenshot. Do you have any idea why Exccel thinks that DJUDJR0 is has no data?

Do you have other filters than the three displayed?

Nope, no other filters.