I am trying to compare the evolution of Sales in a different range of data selected in two different slicers. Specifically I want to compare the sales evolution of this year spring break versus sales evolution of last year spring break. The thing is that spring break is never on the same date so I can not use Time Intelligence functions.
So far I have created two calendar tables, connected by an inactive relationship. This way I can calculate KPIs for these two periods but I can not represent it in a Line Chart.
Any ideas or suggestion would be really appreciated
Thanks in advance.SalesOnSpringBreak.pbix (83.5 KB)