Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help with simple waterfall chart

I'm having problems setting up a simple waterfall chart to show reduction in cost for a business over time. Any help would be much appreciated!   We have the following values in my table (each row ...
Need Help
Show and Tell
Tutorial Requests
littlemojopuppy's avatar
littlemojopuppy
Community Champion
5 years ago

Hi!  To get the waterfall to work, you want to have a measure that calculates period to period change in Cost Reduction.  That gets plugged in as the value, and then use year/month on the axis.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks - so would that measure simply be:

     

    Period Change = Total Annual Cost (£) - Cost Reduction Figure (£)

     

    This would provide a measure that simply provides the new cost figure for each property.

    • littlemojopuppy's avatar
      littlemojopuppy
      Community Champion
      5 years ago

      I guess?  Difficult to say without seeing some sample data or the results of what you're getting.

      I find waterfalls in Excel to be horrible but in Power BI fairly easy as long as you have the measures defined correctly.

      • littlemojopuppy's avatar
        littlemojopuppy
        Community Champion
        5 years ago

        I assume you think the image you posted is not correct?

         

        I think where you're going wrong (but I can't confirm this without having sample data) is that you should be looking for the change in cost from quarter to quarter, not (total annual cost - cost reduction)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Here is a screenshot of what I have achieved so far