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
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

    Thanks - I tried creating that measure and including it into 'value' but its just made it even worse. I'll check out the tutorial you linked to, thanks

    • littlemojopuppy's avatar
      littlemojopuppy
      Community Champion
      5 years ago

      I re-read your original post.  Maybe the problem has to do with the timing of when cost reduction is realized???  If so, you want to look at your data model and specifically with relationships between your date table and the cost reduction date.

      Then you could create a measure that's something like this

      CALCULATE(
	SUM([Period Change]),
	USERELATIONSHIP('Calendar'[Date], 'TableName'[CostReductionDate])
)