Forum Discussion
Slicer
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?
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.
2 Replies
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.