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
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
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.
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |
