Forum Discussion

maxkhan's avatar
maxkhan
Frequent Visitor
1 year ago

Waterfall Chart

I have a table with Planned_Duration and Actual_Duration for a particular task.
How do I make a waterfall chart, that displays all Planned duration on one side and then goes up and down according to the varaince of hours in each task and then shows the actual duration on the left side with date as a filter.

 

Negative variance is good since that means that the task took shorter than expected.

 

I want to sum up the planned durations for one day on one side and then actual durations on the other side with breakdown of variance in between. Which visual is best for this? Please no bar/table charts.

 

4 Replies

  • maxkhan's avatar
    maxkhan
    Frequent Visitor
    1 year ago

    hi saud thanks for ur reply, it doesnt give me what I expect it to since the waterfall visual is supposed to compare the sum of actual duration as to the sum of planned duration on either side for each particular date as a slicer.
    any ideas how I can do this?

    • saud968's avatar
      saud968
      Memorable Member
      1 year ago

      Try the below steps:

      Create Measures:

      Go to the Modeling tab and create the following measures:
      Total Planned Duration = SUM('Table'[Planned_Duration])
      Total Actual Duration = SUM('Table'[Actual_Duration])
      Total Variance = SUM('Table'[Actual_Duration]) - SUM('Table'[Planned_Duration])
      Create the Waterfall Chart:

      Select the Waterfall chart from the Visualizations pane.
      Drag Date to the Category well.
      Drag Total Planned Duration to the Y-axis well.
      Drag Total Variance to the Breakdown well.
      Customize the Chart:

      Click on the chart to select it.
      Use the Format pane to adjust colors, data labels, and other visual settings.
      Add Filters:

      Drag the Date field to the canvas to create a slicer.
      Adjust the slicer to filter the data by date.

      Best Regards
      Saud Ansari
      If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!


      • maxkhan's avatar
        maxkhan
        Frequent Visitor
        1 year ago

        It won't let me add the total variance into the break down field. 😞

  • saud968's avatar
    saud968
    Memorable Member
    1 year ago

    Create the Waterfall Chart:

    Select the Waterfall chart from the Visualizations pane.
    Drag Date to the Category well.
    Drag Planned_Duration to the Y-axis well.
    Drag Variance to the Breakdown well.
    Customize the Chart:

    Click on the chart to select it.
    Use the Format pane to adjust colors, data labels, and other visual settings.
    Add Filters:

    Drag the Date field to the canvas to create a slicer.
    Adjust the slicer to filter the data by date.

    Best Regards
    Saud Ansari
    If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!