Slicer

[Anonymous]

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?

[Gopal30 · Accepted 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. 

[Anonymous]

Hi @Gopal30 ,

Thank you!