Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
11 months ago

Sort Axis on Waterfall Chart

I have a consultation I've generated a waterfall chart in Power BI with the variables CATEGORY: Mg 2025P & Mg 2025R BREAKDOWN: Mg Serv, Mg Eq, C. Op and C. Com Y-axis: Sum of Total M...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
11 months ago

You explain to me how the structure of that table I must create should be. I guess I should do this in Power Query, to indicate the order of this column (Breakdown) and keeping the order of Category

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
11 months ago

Hi Syndicate_Admin ,

You can build this mapping table in Power Query (manually create a small table with those pairs). Once you have it:

  1. Load it into the model.

  2. If it’s a separate mapping table, create a relationship from BREAKDOWN in your fact table to BREAKDOWN in this mapping table, then add the SortOrder column to your fact table via a merge.

  3. In the Data view, select your BREAKDOWN column, then set Column Tools → Sort by Column → SortOrder.

This way, whenever you use BREAKDOWN in the Waterfall chart, it will always respect the custom order you defined, regardless of which CATEGORY or filter you apply.

I hope this information helps. Please do let us know if you have any further queries.
Thank you