Forum Discussion
Grouping by age
Morning all, I thought I'd get a bit of time in Power BI this lovely Saturday morning. I clearly live the rock and roll lifestyle ;-) I have a list of queries for which I have created a measured...
Never mind... it was me ;-)
However it would be useful if I could sort the order:
0-5
6-20
21-50
50>
So I can see a graduated colour change:
If you create a column on your 'Age profile Ranges' table that represents the order you want for each segment, let's say we call it Position and then create a calculated table with two columns, segments and Position, you can define the segments column to sort based on the Position column. This calculated table will be your dimension table that you can relate to your fact table.
Table = SUMMARIZE('Age Profile Ranges';'Age Profile Ranges'[Age Range Name];'Age Profile Ranges'[Position])
You can make the Postion column invisible to the client tools.