Water Chart issues - showing the incorrect PY number - Video provide of Demo Dataset

[PBI-Curious]

Hello PBI Community Good Day!

Video attached, per what I'm trying to accomplish with a Water Fall Chart 

Please contact me with any additional questions

I also have a demo .pbix

Much apprecate your time!

Thank you

[v-yiruan-msft]

Hi @PBI-Curious ,

Could you please share your demo .pbix file(exclude sensitive data) with us in order to make troubleshooting if it is convenient? 

How to upload PBI in Community

By the way, do you mean that the value for 2020(315.6bn) in water chart is wrong? The correct value should be same as the one which display in PY $ card visual?

In addition, the following ones are some links on how to calculate YTD for the previous year. You can check the content in them and hopefully they will help you resolve the problem.

Difference of THIS YEAR YTD and LAST YEAR YTD

How to work out Previous Year to Date in Power BI?

DAX – Getting the Previous Year to Date Value up to and including the Current Month Selected – Not t...

Calculate SAMEPERIODLASTYEAR for Partial Year

Best Regards