Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to change the order that the Position fields appear in on the Axis of a Clustered Column graph.
Currently they just appear in alphabetical order. I want to be able to specify a particular order.
Is this possible?
You can create another column to define the order as you desired. Then use the Sory By function.
Please refer to following documents and thread. Please also let me know if you still have problem on it.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-change-how-a-chart-is-sorted/
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/
https://community.powerbi.com/t5/Desktop/Custom-Sort-by-x-axis-legend/td-p/64402
Best Regards,
Herbert
Hi - I already had an additional field that I was going to use as the Sort By.
However, when I select that field, the Sort By Column remains greyed out - I can't apply it.
Why would that be?
Hi Herbert
I've tried what you suggested but it hasn't been successful. How do I send you the pbix file?
You can share the PBIX file through online file service and send the sharing link here or through private message.
Best Regards,
Herbert
I have sent a private message to you.
Thanks
Please try to create another table to define the order for different roles, then create relationship with the original table as below.
Make the Pos column sorted by Num column.
Use Pos column instead of the Position column in the chart.
Best Regards,
Herbert
Could you please make sure that you only select the Position column before clicking the Sort By button?
If issue still persists, could you please share your PBIX file through online file service like OneDrive?
Best Regards,
Herbert
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |