Forum Discussion

jamesrupertball's avatar
jamesrupertball
Frequent Visitor
3 years ago
Solved

Waterfall Chart - Set as total

Excel has an option to set one or more series as a total in a waterfall chart.

 

 

I can't find the equivalent setting in Power BI, so I am unable to set a starting and ending total.  Is there a way around this?

 

 

I have read about Breakdown but I don't think this is what I need.

  • Hi jamesrupertball ,

     

    According to my knowledge, Power BI Waterfall Chart does not support set as total. You can use custom visual to achieve this goal.

    For example:

     

    Pivot your table:

    Then apply to the visual:

    Final output:

    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.

4 Replies

  • Hi jamesrupertball ,

     

    According to my knowledge, Power BI Waterfall Chart does not support set as total. You can use custom visual to achieve this goal.

    For example:

     

    Pivot your table:

    Then apply to the visual:

    Final output:

    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.

    • jamesrupertball's avatar
      jamesrupertball
      Frequent Visitor

      Thank you, this is what I was hoping Power BI's standard visual would allow me to do.  Thanks for your help.

    • AartiD's avatar
      AartiD
      Helper II

      how to remove Backgroung image -https.? Its is coming while publishing data.

  • Sad how they can update power bi monthly but key features are still missing nearly a half decade later. Walk before you run considering switching back to Tableau.