Data Model: Slicers Not Greying Out Items With No Data

[Nations]

I'm running into issues with some of my slicers displaying the full list of items and not greying out items without any data.

I'm working with a data model with 4 data tables and 2 dimension tables, Location and Employee. Both dimensions have various rollups. I've created the relationships between each dimension and the 4 data tables and connected each slicer to the 4 data pivots.

Now, amongst the slicers within each dimension, the slicer display settings are working great. IE. if I have City -> State, when I select a state, all the cities without data are greyed out and moved to the end of the slicer. However, the Location slicers have no effect on the Employee slicers and vice versa.

Is there a way to have the 2 sets of dimension slicers affect each other? IE. if I select a State, I'd like all the employees without data to be greyed out. I've tried connecting the dimension slicers to each other but it didn't seem to do anything.

Appreciate any help, hopefully this didn't sound too confusing.

 

[Alex Blakenburg]

Try this:
Right click on the slicer and select "Slicer Settings..."

Tick Hide Items with no data.

 

[Nations]

Thanks for the response. I ended up solving the issue.

The problem was the two dimensions weren't linked to each other so I combined them into a single dimension and created surrogate keys to link to the data tables. Things appear to be working now.

 

[Alex Blakenburg]

Thanks for letting me know
Glad you got it sorted.