Creating YoY data is easy by month by using Year in the Legend of the pivot chart.
What I need to do to overlay YoY data by day.
I have daily values of 16 months of data: January-2023 to April-2024.
Is it possible to overlay January-February-March-April data for 2023 and 2024?
Preferably to overlay the same days of the week.
For example, can I have 2 X-axis: the bottom axis for 2023 and the top axis for 2024?
Is there an alternative solution in PowerBI?
Attached is an example of the data.
I'm using Microsoft 365 version 2402.
Bookmarks