Waterfall Chart

[Ashish9201]

Hi All,

I am trying to replicate below Waterfall chart created on excel with some additional breakdowns.

There are couple of issues that i have noticed,

1) My chart is not following the orders that i have setup

2) The Value for each breakdown is coming up as a difference in (Total Available and Approved BT Hours) 

Below is the formula that i have used,

Categories =

SWITCH (

    SELECTEDVALUE ( 'WF Category'[Walk Start] ),

    1,

        SWITCH (

            SELECTEDVALUE ( 'WF Category'[Cat] ),

            "Missing Hours", -1 *[Missing Hours],

            "Recall/Returned Hours", -1 * [Recall/Returned],

            "Administration", -1 * [PW Administration],

            "Time Available", -1 * [PW Time Available],

            "Pre-Sales", -1 * [PW Pre-Sales],

            "Training", -1 * [PW Training],

            "New Hire Training", -1 * [PW New Hire Training],

            "Recruiting", -1 * [PW Recruiting],

            "PTO", -1 * [PW PTO],

            "Holiday", -1 * [PW Holiday],

            "Int-Proj Hours", -1 * [PW Int-Proj],

            "Int-Prod Hours", -1 * [PW Int-Prod],

            "Other UnRec Hours", -1 * [PW Other UnRec2],

            "Other UnRec Mitigated Hours", -1 * [PW Other UnRec Mitigated Hours],

            "Client Activity Hours", -1 * [PW Client Activity Hours],

            "Client Billable Hours", -1 * [PW Client Billable],

            "Client Non-Billable", -1 * [PW Client Non-Billable],

            "Client BT - Draft", -1 * [PW Client BT - Draft],

            "Client BT - Submitted", -1 * [PW Client BT - Submitted],

            [Available Hours]

        ),

    2,

        SWITCH (

            SELECTEDVALUE ( 'WF Category'[Cat] ),

            "Missing Hours", 0,

            "Recall/Returned Hours", 0,

            "Administration", 0,

            "Time Available", 0,

            "Pre-Sales", 0,

            "Training", 0,

            "New Hire Training", 0,

            "Recruiting", 0,

            "PTO", 0,

            "Holiday", 0,

            "Int-Proj Hours", 0,

            "Int-Prod Hours", 0,

            "Other UnRec Hours", 0,

            "Other UnRec Mitigated Hours", 0,

            "Client Activity Hours", 0,

            "Client Billable Hours", 0,

            "Client Non-Billable", 0,

            "Client BT - Draft", 0,

            "Client BT - Submitted", 0,

            [PW Approved BT Hours]

        )

)

Can someone please help me correct the chart?

Regards,

Ashish Gupta

[Ashish9201]

Hi @Anonymous ,

Please find below link of the sample dataset.

Let me know if you have any issue in accessing the file.

Need your help on waterfall chart.

Link - https://highmetric-my.sharepoint.com/:u:/r/personal/ashish_gupta_newrocket_com/Documents/Desktop/Sample%20Dataset.pbix?csf=1&web=1&e=zHxoqJ

Thanking you in advance!

Regards,

Ashish Gupta

[Anonymous]

Hi  @Ashish9201 ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly