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
Icon for Community Champion rankCommunity 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.

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
    Icon for Community Champion rankCommunity 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])
)