Forum Discussion

sjpaq's avatar
sjpaq
Helper I
3 years ago
Solved

Sorting the x-axis on a stacked column chart

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,...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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.