SORTING IN A GRAPH BY NUMERICAL NUMBER

[Anonymous]

Hello

I am having issues sorting the below from number 1 to 12. Anything after 9 sorts after 1 etc. Any tips on how to solve please?

[amitchandak]

@Anonymous , Take out these number in a new column , that should be numeric column,

Mark that a sort column for this and then it will sort correctly

Refer: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous · Accepted solution]

Hi Amitchandak

Thank you for you feedback.

I do have the numeric value in a seperate column and sorted this in the column tools sort by column and chose the field name of POSITION (numeric only). It did not work as this field is not in my stack graph so was not able to sort by this column.

However being trouble shooting for the last hour and I came right. This is what I did. I put the POSITION column under Tooltips then sorted by POSTION (as can be seen in the graph sort) then sort by ascending. Wholla it works now.