Define Decrease Parameter Field for Waterfall Chart

[Anonymous]

Hi,

I want to make a waterfall chart showing the amount of open and closed notifications per year. Do you know how to define the closed notification to always be the decreasing one? So in the final year, the formulation would be:

the amount of notification from last year + open notification - closed notification

I also don't understand why there is another legend for "Other" here in the yellow dot.

Thanks.

Vano.

[Anonymous]

Hi @Anonymous ,

Could you please share some sample data with Text format and the field or measure which applied in waterfall chart in order to provide a suitable solution? Thank you.

Best Regards

[Anonymous]

Hi @Anonymous ,

The raw data would be looked like below:

Notification             Date                     Status

AAA                         1-1-2018              Open

AAB                         17-6-2018            Closed

AAC                         27-10-2018          Closed

AAD                         1-1-2018              Closed

DFG                         17-8-2019            Open

DRF                          7-10-2019           Open

DCF                         18-11-2019          Closed

SDE                          5-1-2020             Open

DFE                          11-6-2020           Open

I want to have the count of notification for each consecutive period (in date hierarchy) which shows the increasing trend for "Open" and decreasing trend for "Closed".

[Anonymous]

Hi @Anonymous ,

I created a sample pbix file(see attachment), please check whether that is what you want.

Best Regards

[Anonymous]

Hi @Anonymous ,

Thank you for creating the sample file!

It is a great formulation, but I found the "closed" status still appeared increased at the waterfall chart. Can you make it always decreased for the "closed" status?

Best regards,

Vano.