topic Re: Help on one Waterfall chart in DAX Commands and Tips

Help on one Waterfall chart

ssysanny — Mon, 08 Aug 2022 12:03:43 GMT

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

Re: Help on one Waterfall chart

ssysanny — Mon, 08 Aug 2022 14:15:41 GMT

expected chart

Re: Help on one Waterfall chart

Ethan96 — Wed, 10 Aug 2022 09:11:52 GMT

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

Re: Help on one Waterfall chart

ssysanny — Wed, 10 Aug 2022 09:10:47 GMT

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