Bar chart not sorting correctly

[Anonymous]

Very good morning,

I am facing troubles sorting my bar chart.

Below is my data from Excel.

And here is the result. I am sure this is due to the intervals. Any trick to sort from low to high.

Thx

Thomas

[Tahreem24 · Accepted solution]

@Anonymous ,

Create one calculated column for sorting:

Sorting = SWITCH('Table[Range],"25000-100000",1,"100000-500000",2,"500000-1000000",3,">1000000",4)
Then go to Data View --> Then select the range column --> click on "Sort by Column" option then choose Sorting column which is created above. Then yor Range column will get sorted by Sorting column order.