Waterfall Chart for discrete periods

[Anonymous]

Hi,

I am looking for a solution or alternate options to achieve the following requirement in Waterfall chart.

Starting bar: 2020 Wk1 Sales

Ending bar: 2021 Wk1 Sales

Distribution: Regions e.g. NA Bar = 2021 -> wk1 ->LFL Sales -> NA  - 2020 -> wk1 ->LFL Sales -> NA

Individual region contribution to sales growth from last year wk1 to current year wk1. I don't want to display the in between periods.

Thanks

Naveen Suram 

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

You can try to select the first week of 2020 and 2021 on the filter. This is a waterfall chart I created based on sample data.

This is my PBIX file.

https://microsoftapc-my.sharepoint.com/:u:/g/personal/v-lazhang_microsoft_com/EQ_1IHDe_iZMqi-4fjVf14oBViRX2dfQKxmi871tDhtzaQ?e=Mg38mW

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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