Forum Discussion
Bar chart not sorting correctly
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
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.
1 Reply
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.