Forum Discussion

Venugopalchari's avatar
Venugopalchari
Regular Visitor
8 months ago
Solved

How to manually sort Breakdown values in a Power BI Waterfall chart when using Field Parameters?

I am facing an issue with sorting values in the Breakdown section of a Waterfall chart in Power BI. My requirement is to manually control the sort order of the Breakdown values. However, Power BI do...
  • Kedar_Pande's avatar
    8 months ago

    Venugopalchari 

    You can’t manually sort Breakdown when it’s coming from a field parameter

    Workaround:

    Helper column + normal column (no parameter)

    Create a SortOrder column for your breakdown items.

    In the model, set BreakdownColumn -> Sort by column -> SortOrder.

    Use that column directly in Breakdown (not via field parameter).

     

    If this answer helped, please click Kudos or Accept as Solution.
    -Kedar
    LinkedIn: https://www.linkedin.com/in/kedar-pande

  • Royel's avatar
    8 months ago

    I am agreed with Kedar_Pande 

    This is a known limitation in Power BI Waterfall charts. The Breakdown section doesn't respect custom sort orders when driven by Field Parameters because:

    • Field Parameters are essentially calculated tables with their own ordering logic
    • The Waterfall visual's Breakdown bucket has limited sorting capabilities compared to Category or Y-axis

    If you need to maintain the flexibility of Field Parameters elsewhere while having sorted Breakdowns, you might need to create a separate, dedicated column specifically for Waterfall chart breakdowns with the sort-by-column relationship configured.

     

    Thanks