How to custom sort x axis in bar chart

[ShreyasK]

I have bar chart which shows floor wise cout of employees. I wanted to sort visual by floor sequence like - Basement, Ground Floor, 1st Floor and then 2nd Floor (Left to right) but since floor names contains number & alphabets I am not able to sort it in required sequence. When I sort axis by floor ascending order then bar chart looks like below -

I want to see in this sequence - Basement - Ground Floor - 1st Floor - 2nd Floor.

I tried by creating Floor table with Sr.No and merged it with my orginal database table but still not getting the required result.
Floor table

Can anyone suggest, How this can be achieved..?

[ShreyasK]

@PaulDBrown - Thank you very much..!!! This worked perfectly 😊

[PaulDBrown · Accepted solution]

You need to sort the Floor column by the sort order column in the table view

Then sort the axis in the visual by Floor in ascending order