Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have some category types for each record in the dataset.
These categories are represented in columns.
I need to create a slicer that can show each category and filter the records accordingly.
The issue is that one record can be in multiple categories.
Sample data:
Employee | Category X | Category Y | Category Z |
John | 1 | ||
Mike | 1 | ||
Joe | 1 | ||
Chandler | 1 | 1 | 1 |
In the above example, my slicer will have three choices: Category X, Category Y, Category Z.
How can I add the 3 categories in one slicer and make it so that Chandler is available in all 3 categories?
Solved! Go to Solution.
You need to unpivot the data, so you can work with all the categories.
Check the attached file.
You need to unpivot the data, so you can work with all the categories.
Check the attached file.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |