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.
Hi,
I'm trying to have cuztom order of the X axis of a column chart. I can't manage in the chart to have the correct order of column (it should be 2016 / 2061 - Ref / 2061 - Intermédiaire / 2016 - Final). I found some solutions on the forum saying I should create a new variable with values 1-2-3-4 corresponding to the order I want. However, when I do that, those values (1-2-3-4) appear on the label of the X axis (see screenshot). I also saw some other solutions, but it looks like they are not available with PBI Desktop.
My data are:
Scenario | A | F | O | Order |
2016 | 0.107218 | 0.800468 | 0.092314 | 1 |
2061 - Ref | 0.145449 | 0.714009 | 0.140542 | 2 |
2061 - Intermédiaire | 0.145278 | 0.736339 | 0.118383 | 3 |
2061 - Final | 0.144504 | 0.753834 | 0.101662 | 4 |
Solved! Go to Solution.
@Demographer , have you marked Order as the sort column for Scenario and sorted the visual on Scenario using three dots
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Hi @Demographer ,
You don't actually need to use your custom sorting column inside the visual. instead use the sort by column functionality to sort the campaign column by the custom sorting column:
Select the campaign column, navigate to the "Sort by column" and then select your sorting column. This requires a 1 to 1 relationship between the values, meaning that there can not be two campaigns with the same sorting value and vice versa.
Br,
J
Thank you for you answer @tex628 . Maybe there is something I did wrong, but it still doesn't work.
I sorted column by scenarios.
However, the order in the chart is still wrong (2061 - Ref and 2016 - Final should swap). I try to reassign order with the ..., but still no result.
Same...
It works only if I include "Order" in the X axis. But then, the labels include the value 1/2/3/4.
Yes, the column 2061-Final should be the last on the right. The column 2061-Ref should be the second from the left (as in the original data).
It's still not working even after applying the same steps that im doing in the gif above?
/ J
Sorry I didn't realize it was an animated gif. Yes, now it works! Thanks for the tutorial.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |