Define Decrease Parameter Field for Waterfall Chart

Question

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&nbsp;I also don't understand why there is another legend for "Other" here in the yellow dot.&nbsp;Thanks.Vano.&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
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 · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;The raw data would be looked like below:&nbsp;Notification&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;StatusAAA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1-1-2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OpenAAB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17-6-2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ClosedAAC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27-10-2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ClosedAAD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1-1-2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ClosedDFG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17-8-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OpenDRF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7-10-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OpenDCF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18-11-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ClosedSDE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5-1-2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OpenDFE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11-6-2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Open&nbsp;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 · Answer

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

Best Regards

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Thank you for creating the sample file!&nbsp;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?&nbsp;Best regards,Vano.&nbsp;

Forum Discussion

Define Decrease Parameter Field for Waterfall Chart

4 Replies

Related content

Waterfall Chart Not Showing Decreases

Waterfall Chart is not showing decreases

Waterfall Chart not showing Decreases

Waterfall Chart

Waterfall Chart Help