Help on one Waterfall chart

[ssysanny]

 thanks for all of your help.

just want to do one waterfall chart , the begin point is the earliest date data  and the end point is the last date data .if there is  no transaction after that date, the future date  should be ignored or hidden.

the x-asix is by year and month composite label as sample.  

thanks for your help. 

https://1drv.ms/u/s!AqYSh-5UaI9Wg11t7eQfCbI1uYUr

[ssysanny]

expected chart

[Ethan96]

Hi, @ssysanny 

I cannot access the attachment for personal reason.

I made a sample based on the screenshot information you provided, hoping it will be useful to you.

Sample pbix

Fields placed on the X-axis of the Waterfall chart should not have duplicate values.

You may need to create the chart based on the field "YEAR_Month" instead of field "Month".

Reagrds,

Ethan

[ssysanny]

thanks your very much and will check it. thanks for your time and energy.