more values showing up in table than in slicer using same field

[faerewatson]

I am using the same field in my slicer as in my table (Group Name). The slicer is showing only the Group Names that have data associated with them in the fact table. The table is showing ALL Group Names. Both of these are using the same dimension table - it seems as soon as I add any data from the fact table, the list of Group Names changes. I can see why this would happen (seems like it is the opposite of what one might expect) - but I need my slicer to match my table (either with all Group Names or just the subset). Any ideas?

[v-ljerr-msft · Accepted solution]

Hi @faerewatson,

---

---

but I need my slicer to match my table (either with all Group Names or just the subset).

In this scenario, I would suggest you add a visual level filter([Count] is greater than 0) on Table visual to filter out the Group Names whose [Count] is 0. 

Regards

[faerewatson]

You are awesome @v-ljerr-msft - thanks for your help!

[v-ljerr-msft]

Hi @faerewatson,

Great to help! Could you accept my reply above as solution to close this thread? 

Regards