Waterfall Chart - Current vs. Prior

[bensiqc]

I want to build a waterfall chart that shows how / why cost increased over time from one month to the next. For now I'm looking at two periods: Last Month and This Month.

What I'd like is this:

One bar representing Cost Per Piece for Prior Month

Three bars in between breaking down increases / decreases in Freight, Fuel, and Other Charges

Then a second large bar represetning Cost Per Piece for Current Month.

The answer in this thread was very helpful. I've created a table with my measures / index (representing freight, fuel, and other).

https://community.powerbi.com/t5/Desktop/Waterfall-Chart-using-multiple-measures/m-p/439275

What I've got is this:

How can I update this so I see one large bar representing total cost for the prior month and one large bar representing total cost for the current month with the incremental steps in between showing the changes in freight, fuel, and accessorial that drove the difference between the two? For what it's worth, I have measures built to show each of these values for both the current and prior month and I have measures to show the difference between them as well.

[lbendlin]

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?

[bensiqc]

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.

[bensiqc · Accepted solution]

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:

[Anonymous]

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

[bensiqc]

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.