Waterfall chart help

[v-easonf-msft · Accepted solution]

Hi, @NDD 

Please try following steps to create water fall chart.

1.Enter two table as below:

2.Add a mesure like:

Value =
VAR a = [Forecast Capacity]
RETURN
    SWITCH (
        SELECTEDVALUE ( 'Categroy Table'[Category] ),
        "Forecast",
            SWITCH (
                SELECTEDVALUE ( 'Breakdown Table'[Breakdown] ),
                "Total Time", -1 * Table1[_Total Time],
                "Unproductive Time", -1 * [_Unproductive Time],
                "Over Time", -1 * [_Over Time],
                [Forecast Capacity]
            ),
        "Real",
            SWITCH (
                SELECTEDVALUE ( 'Breakdown Table'[Breakdown] ),
                "Total Time", 0,
                "Unproductive Time", 0,
                "Over Time", 0,
                [_real]
            )
    )

Then apply these new fields to waterfall chart like below:

Best Regards,
Community Support Team _ Eason

[khalife]

hello ! 

This is very close to what I am trying to achieve. My idea is to always go from 100% and go down to multiple not only one result (blue column) as per below photo.  I hope you are able to help and many thanks in advance ! 

[AUDISU]

Hi @NDD 

Could you please show me your expected Waterfall Chart?

Please draw in a paper and attach the picture.

Thank you