Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
I have a column stacked graph and want to sort the X-axis using a custom sort (ie it's not alphabetical order). I want to display the x-axis in a particular order. How do i do this?
Thanks
Solved! Go to Solution.
Hi @kkjoy81 ,
amitchandak's link is about add a sort in date table. I think you want to add a new sort for text format column in your table. If you add a custom sort by dax with IF() function, you will get a circule error. Here I suggest you to add a custom sort in Power Query Editor. Add a custom column by Conditional Column Function.
Then sort the column in X axis by this sort column. You may refer to the offical blog mentioned by amitchandak to learn more details about how to sort a column by another column.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @kkjoy81 ,
amitchandak's link is about add a sort in date table. I think you want to add a new sort for text format column in your table. If you add a custom sort by dax with IF() function, you will get a circule error. Here I suggest you to add a custom sort in Power Query Editor. Add a custom column by Conditional Column Function.
Then sort the column in X axis by this sort column. You may refer to the offical blog mentioned by amitchandak to learn more details about how to sort a column by another column.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@kkjoy81 , Create a sort column and mark that as sort column
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
89 | |
71 | |
69 |
User | Count |
---|---|
228 | |
128 | |
117 | |
83 | |
82 |