Forum Discussion

NDD's avatar
NDD
Frequent Visitor
4 years ago
Solved

Waterfall chart help

 

 

  • 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

3 Replies

  • AUDISU's avatar
    AUDISU
    Resolver III

    Hi NDD 

    Could you please show me your expected Waterfall Chart?

    Please draw in a paper and attach the picture.

     

    Thank you

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    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's avatar
      khalife
      New Member

      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 !