Cuztom order of X axis

[Demographer]

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

[amitchandak]

@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

[tex628]

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

[Demographer]

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.

[tex628]

Sort by "Order" instead of scenario!

[Demographer]

Same...

It works only if I include "Order" in the X axis. But then, the labels include the value 1/2/3/4.

[tex628 · Accepted solution]

I've tried to recreate your scenario below:

/ J

[Demographer]

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).

[tex628]

It's still not working even after applying the same steps that im doing in the gif above?

/ J

[Demographer]

Sorry I didn't realize it was an animated gif. Yes, now it works! Thanks for the tutorial.