Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |