Ignore All Filters And show Last 12 Month From Selected Period

[aOliverzZ]

Hey All,

My data is always filltered by 2 time slicers: Year and month.

I have simple measure:  Negative Items % = DIVIDE([Negative Items], [#Items]) from Fact_Table; and a Date Dimmension connected to it.

I want to show a Line chart of the selected period and last 12 month.

for example, if I selected April, 2020, I want to see a Line chart of April, 2019 to April 2020.

Any Ideas?

Thanks 🙂 

[amitchandak · Accepted solution]

@aOliverzZ , You have to follow the approach suggested in this video

https://www.youtube.com/watch?v=duMSovyosXE