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 column to calculate how old they are in days. What I'd like to do now is create a seperate column which categories them into 4 age brackets:
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.
Currently, there is no such a 'sort by legend' option supported in chart visual, so we are not able to customize the order of legend. However, as a workaround, you could create Measures for each type of Days, then place each Measure in the Values area in the order you wish. Reference: Rearrange Pies in Pie Chart
Regards, Yuliana Gu
Community Support Team _ Yuliana Gu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.