Waterfall Chart

[maxkhan]

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.

[maxkhan]

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]

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]

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

[saud968]

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!