When I sort by age group on the graphs it does not filter correctly, it puts ages 5-9 in the middle and not right after 0-4. I would like to turn off the sort on the graph so it just appears as the data appears in the table. Can this be done?
Hi @JJL_Ptbo ,
If you want to sort the X axis, you need to have reference columns.
Because your current 5-9 is text, you can't sort it.
In fact, the x-axis can be sorted correctly by adding indexed columns.
You can try this method:
This is my test data:
When I use this table to sort by year column, I got the result below:
It is the same quertion with you.
So I add an index column in Power Query:
And then I got the table like this:
Then you can choose the year column and select the Sort by Column:
Finally you can sort it correctly:
Hope this helps you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @JJL_Ptbo ,
If you want to sort the X axis, you need to have reference columns.
Because your current 5-9 is text, you can't sort it.
In fact, the x-axis can be sorted correctly by adding indexed columns.
You can try this method:
This is my test data:
When I use this table to sort by year column, I got the result below:
It is the same quertion with you.
So I add an index column in Power Query:
And then I got the table like this:
Then you can choose the year column and select the Sort by Column:
Finally you can sort it correctly:
Hope this helps you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
