Lines with quarters in the good order

[joc]

Hello everybody,

I need your help again.

I have this data :

And I have this graph :

But, the quarter "Q4 2015" is not at the good position. I would like to move this line before "Q1 2016". I dont know how to do that. I specify that I display the last 5 quarters, and I can have the sames problems with new quarters. 

Thank you in advance for your help,

Joc

[v-sihou-msft · Accepted solution]

@joc

In this scenario, your TRIM column is "Quarter + Year" text. It will sort based on characters. If you want to have it sort by Year, you need to have a year column and change it to "Whole Number" type.

Year = RIGHT(Table1[TRIM])

Then change "Sort by Column" into Year column for TRIM column.

Regards, 

[Seth_C_Bauer]

@joc Same response I added to this question you had about axis.

http://community.powerbi.com/t5/Desktop/Exchange-the-legend-and-the-abscissa-axis/m-p/173137#M75616