Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a table showing the events attended by individuals. I want to use the Event Type slicer to change only the values in the table, not the number of rows (count of members). Is it possible to use a slicer without changing the number of rows in a table while still changing the values in the table?
Above, you can see that when the filter is selected, it filters out anyone who hasn't been to a DC event (about 15 people). I dont want those 15 removed, I just want their values in the table to become blank/0. Any tips?
Solved! Go to Solution.
Hi @Anonymous ,
In your scenario, we can create a Event Type table without relationship between the fact table, then use the calculate (***,filter(all([Event Type]), *** = allselected([Event Type])))
Best Regards,
Teige
Hi @Anonymous ,
In your scenario, we can create a Event Type table without relationship between the fact table, then use the calculate (***,filter(all([Event Type]), *** = allselected([Event Type])))
Best Regards,
Teige
I'm not sure I understand.
I create a new table with the event types and then create a measure with (***,filter(all([Event Type]), *** = allselected([Event Type]))).
And then doing that I can create a slicer that will adjust the counts?
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |