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