Waterfall chart with the data of the selected year (in a slicer) and the year before

[webportal]

How to show a waterfall chart with the data of the selected year (in a slicer) and the year before?

Like:

Should the user change the year of the slicer to 2019, the chart should display 2018 vs 2019.

[v-lionel-msft · Accepted solution]

Hi @webportal ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[webportal]

Tricky 😉
Thanks for helping!