Forum Discussion
Waterfall Chart - Current vs. Prior
Okay, I figured it out. Solution below for posterity:
- Built measures for the delta between current and prior month
- Updated my "Waterfall Value" measure to use: CPP Prior Month (total), Net Freight Delta, Fuel Delta, Accessorial Delta
- Added a total column which reprents the curent month
It looks like this:
Doesn't sound like a waterfall chart is the right vehicle for the story you are trying to tell. Have you considered using other visuals?
I've done something similar in Excel that I'm trying to emulate.
It looks like this:
And uses these values:
I set the second CPP as total in the series options:
I just want to emualte exactly this in Power BI if at all possible.
Okay, I figured it out. Solution below for posterity:
- Built measures for the delta between current and prior month
- Updated my "Waterfall Value" measure to use: CPP Prior Month (total), Net Freight Delta, Fuel Delta, Accessorial Delta
- Added a total column which reprents the curent month
It looks like this:
Hi Bensiqc,
Can you share how you build the "Waterfall Value" measure to use: CPP Prior Month (total), Net Freight Delta, Fuel Delta, Accessorial Delta?
I want to build similar waterfall chart but I do not know what measures to create in order to achieve this.
Thanks, Doris
Here's what I have.
My waterfall measure is written this way:
And I have a separate sheet where I add the index for those that looks like this:Measure Index CPP Prior Month 1 Net Freight Per Package Current vs Prior 2 Fuel Per Package Current Vs Prior 3 Accessorial Per Package Current Vs Prior 4 CPP Current Month 5 Hopefully this helps.Each of the measures referenced in the table (fuel per package current vs prior, etc.) were also created and added by me individually.