topic Sorting the x-axis on a stacked column chart in Developer

Sorting the x-axis on a stacked column chart

sjpaq — Sat, 28 Jan 2023 13:45:07 GMT

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

Re: Sorting the x-axis on a stacked column chart

v-jianboli-msft — Mon, 30 Jan 2023 03:04:52 GMT

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.

Re: Sorting the x-axis on a stacked column chart

hariram2 — Mon, 30 Jan 2023 04:50:22 GMT

Hi,

Please follow below steps

1.Goto data model in power bi desktop

2.Goto sort by column

3.And check the Bar chart