Forum Discussion

ssysanny's avatar
ssysanny
Frequent Visitor
4 years ago

Help on one Waterfall chart

 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

3 Replies

    • Ethan96's avatar
      Ethan96
      Resolver I
      4 years ago

      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's avatar
        ssysanny
        Frequent Visitor
        4 years ago

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