Looking to sort the breakdowns in a custom order. I've created an index for the category to Map Depreciation = 1, Supplies = 2, etc.
However when I sort by axis, the category is not an option for me to sort by. Are there any other ways that I can sort the breakdown?
Hi @jnguyen21 ,
Hope everything is going well.
Judging from the screenshot you provided, your Category contains FiscalYear, and your sorting is based on Sum of New YTD.
Do you want to sort based on FiscalYear? If yes you can do this:
I provide an example so that you can better understand the sorting of waterfall charts.
1. First, create a waterfall chart, with Y axis as "Total Sales Variance" and Category as "FiscalMonth".
2. Sort in descending order according to "FiscalMonth". At this time, August has the largest difference and January has the smallest difference.
3. Sort in descending order according to "Total Sales Variance". At this time, March has the largest positive difference and July has the largest negative difference.
If you want to know more about waterfall chart sorting, please refer to the following document. The fourth item in his directory is about waterfall chart sorting.
Waterfall charts in Power BI - Power BI | Microsoft Learn
If I misunderstood your question, I would be grateful if you could provide a more detailed description of the problem or a Power BI Desktop file.
If you have any concerns or if I can help you, please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi @jnguyen21 ,
Hope everything is going well.
Judging from the screenshot you provided, your Category contains FiscalYear, and your sorting is based on Sum of New YTD.
Do you want to sort based on FiscalYear? If yes you can do this:
I provide an example so that you can better understand the sorting of waterfall charts.
1. First, create a waterfall chart, with Y axis as "Total Sales Variance" and Category as "FiscalMonth".
2. Sort in descending order according to "FiscalMonth". At this time, August has the largest difference and January has the smallest difference.
3. Sort in descending order according to "Total Sales Variance". At this time, March has the largest positive difference and July has the largest negative difference.
If you want to know more about waterfall chart sorting, please refer to the following document. The fourth item in his directory is about waterfall chart sorting.
Waterfall charts in Power BI - Power BI | Microsoft Learn
If I misunderstood your question, I would be grateful if you could provide a more detailed description of the problem or a Power BI Desktop file.
If you have any concerns or if I can help you, please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
In the data view, select the column "Category", click "Sort by column". Here, by default it will show the category column. Now, you click the custom "Index" column you created.
Go back to report view and the order should be as per the index.
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Power BI Monthly Update - July 2026
Check out the July 2026 Power BI update to learn about new features.
Data Days 2026
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
