Sorting the x-axis on a stacked column chart

[sjpaq]

The x axis is showing fiscal years which are stored as text(4) (not numeric). The chart appears to be sorted by fiscal year descending, I would like it ascending. Also, could I sort it by bar height, either shortest to tallest or talles to shortest.

Thanks in advance for the help

[hariram2]

Hi,

Please follow below steps

1.Goto data model in power bi desktop

2.Goto sort by column

3.And check the Bar chart

[v-jianboli-msft · Accepted solution]

Hi @sjpaq ,

When you're editing a report in Power BI, you can choose a column to define the sort order of another column.

Here's a common example. You have a Month Name column, and when you add it to a visual, the months are being sorted alphabetically: April, August, December, February, and so on. However, you want them to be sorted chronologically. This article shows how to set the sort order of one column by a different column, in Power BI Desktop or in the Power BI service.

For more details, please refer to:

Sort one column by another column in Power BI - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.