Slicer from hierarchy does not "hide items with no data" (bug or feature)?

Occasional Contributor



I have an Excel Data Model table that contain a hierarchy called Geography, that contains the following levels:

1. Country

2. State

3. City


When I insert a slicer for this hierarchy will automatically add 3 slicers for each of the fields.

If I configure all the slicers to "Hide items with no data", but selecting a Country will not hide the other countries States, will only "select" all the states of the selected Country.


As a "workaround" if I delete the State slicer added from hierarchy and add it from the "normal field" with the same name, in this case will show only the states from the selected Country.




In this case what would be the "benefit" of using a hierarchy?... just to have the slicer added automatically and connected to the same source as the main level of the hierarchy?


Is this a bug or is the "intended use"?


Kind Regards,


1 Reply
best response confirmed by Lucian_C (Occasional Contributor)


I believe that's by design.