Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone!
I have a data set about the number of residents from 0 to 10 years for several areas and years. The data set has information per age, so for the age 0, 1, 2, ... 10. I have combined these numbers, because I wanted to minimize the table. That is why I want to create a slicer for age, so that you select the age(s) yourself. However, I don't know how to do this. Can anyone help me?
Solved! Go to Solution.
Ok , instead of combining all the columns you can unpivot the columns 0 to 10 in Query editor which will reduce the number of columns to one with all the ages in a single columns with multiple rows.
So once you have Ages and values as column you can select them as Slicer.
If that's what you are looking for.
Ok , instead of combining all the columns you can unpivot the columns 0 to 10 in Query editor which will reduce the number of columns to one with all the ages in a single columns with multiple rows.
So once you have Ages and values as column you can select them as Slicer.
If that's what you are looking for.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |