how to arrange data in chart ( axis )

[MostafaGamal]

Hi all, 

I have a table like this 

when i use it in a chart the axis values are not arranged is not as in the table, i wnat it to be arranged as in the table ( July - august - September - ........ ) , how to do that ?? 

i tried to make a column from 1 to 12 and use sort by column function in column tool but it didnt work 

[Greg_Deckler]

@MostafaGamal - Well, you had the correct idea using a Sort by column. How is the table visual sorted? Not sure why it would not work in your line chart using the Sort by, that is a very common way to do what you are trying to do. And when you say didn't work are you saying you got an error trying to do it or that it didn't sort properly?

[MostafaGamal]

@Greg_Deckler 

i have done like what you have done in your file and still the same problem, i dont know what is the issue now  

[Greg_Deckler]

@MostafaGamal Make sure that your Sort on your visual is correct:

[MostafaGamal]

@Greg_Deckler  by it didnt work i mean that the data is not sorted correctly as i want or as it exists in the table 

i didnt know what you mean by " How is the table visual sorted " ? 

[Greg_Deckler · Accepted solution]

@MostafaGamal - See the attached PBIX file below sig. You want Page 34, Table (34):

[MostafaGamal]

@Greg_Deckler 

thanks it works fine now the problem was that the type of the index column was text when i convert it to whole number it works fine 

[Greg_Deckler]

@MostafaGamal - Ah, shoot, I should have thought of that!!