Forum Discussion
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 ...
You should get a message that I'm requesting permission to download
Howdy! So I found this article and am trying to implement it, with some success.
I'm able to get the starting and ending values to appear in the waterfall. But the year to year changes aren't properly reflected. What's even more odd is they are showing up correctly in a matrix, so I'm inclined to think there is some kind of oddity specific to waterfall charts.
The code for the measure being used in the waterfall is as follows...
Bridge Values =
SWITCH(
TRUE(),
ISFILTERED('Calendar'[Year]),
CALCULATE(
[Total Cost Reductions],
KEEPFILTERS('Calendar'[Year])
) * -1,
ISFILTERED('Waterfall Walk'[WalkStart]),
SWITCH(
SELECTEDVALUE('Waterfall Walk'[WalkStart]),
"Opening Balance",
[Total Cost],
"Ending Balance",
[Targeted Annual Cost],
BLANK()
),
BLANK()
)
At the moment I'm kind of hoping that Anonymous or another moderator can offer an idea...but will still keep trying
Thank you so much, I really appreciate the effort! Hopefully we (the 'Royal' we) can somehow get it working