Forum Discussion

bensiqc's avatar
bensiqc
Helper I
3 years ago
Solved

Waterfall Chart - Current vs. Prior

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: ...
Need Help
  • bensiqc's avatar
    bensiqc
    3 years ago

    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:

     

     

     

     

lbendlin's avatar
lbendlin
Super User
3 years ago

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's avatar
    bensiqc
    Helper I
    3 years ago

    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's avatar
      bensiqc
      Helper I
      3 years ago

      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's avatar
        Anonymous
        Not applicable
        3 years ago

        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