Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Hi @faerewatson,
Great to help! Could you accept my reply above as solution to close this thread?
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |