Forum Discussion

Koushikrish's avatar
Koushikrish
Helper I
4 years ago
Solved

Waterfall Chart - Ratio (Divide By) Measure Total Issue

Hello,   I have a Ratio measure that is a division of a Measure on another Measure on my PowerBI Model. This is the measure :   AmountPerOrder= DIVIDE([Amount], [TotalOrders])   I am trying to ...
  • v-yalanwu-msft's avatar
    4 years ago

    Hi, Koushikrish ;

    This is by design. The total value of the waterfall chart is based on the previous sum and cannot be changed, but can be cancelled. Perhaps you can add another column as total and cancel the total column;
    or  you may vote the idea and comment there to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

    https://ideas.powerbi.com/ideas/


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.