Solved: Bar chart not sorting correctly

Anonymous · ‎02-16-2021

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 · ‎02-16-2021

@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.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

Tahreem24 · ‎02-16-2021

@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.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard