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.
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.
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
