Forum Discussion
Sorting X and Y axis in Charticulator
Hi Anonymous ,
Actually, Power BI sort the text type values based on normal alphabetical order, so you would find age group 5-12 is after 30-49 and calls group 11+ is before 6-10... You can refer the content in the following links to make a custom order by creating a order table:
Sort a Column with a Custom Order in Power BI
Best Regards
Hi Anonymous ,
Could you please provide the related screenshots of chart visual display in Charticulator and Power BI separately? And please provide the sorting rules if it is possible. Thank you.
Best Regards
Hi Anonymous
Many thanks for your reply.
Here are the screenshots.
The dataset was exported from a Power BI table visual as .csv file. This table has three columns
1. Age group - This group is created in Power BI and a sort column was created to order it
2. Calls group - This group is created in Power BI and a sort column was created to order it
3. No. of calls (Power BI DAX measure)
These groups are showing up as expected in the Power BI default visuals like matrix. Showing up as sorted.
*Note - i tried to sort X and Y axis in Charticualtor which allows you to chanage the order of the X and Y axes labels. I manually reordered them with a drag-and-drop interaction.
Hi Anonymous ,
Actually, Power BI sort the text type values based on normal alphabetical order, so you would find age group 5-12 is after 30-49 and calls group 11+ is before 6-10... You can refer the content in the following links to make a custom order by creating a order table:
Sort a Column with a Custom Order in Power BI
Best Regards
Hi Anonymous
Thanks for looking into it.
Age group and Calls group are Power BI groups based on Age and call columns and I have already created sort columns in Power BI and sorted Age group and Calls group by those columns. Age group and Calls group show up as sorted in Power BI default visuals.
Hi Anonymous ,
If you apply this custom sort to your custom chart visual, will it also work or not?
Best Regards