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 the...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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
3 years ago

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