Get last 12 months on linechart

[Lore_BI]

i have a slicer on my report where i filter on year and month: 

Now i have some measures i want to plot on a linechart, for the selected slicer date and the 12 months before that;  so it would look like this: 

Can anyone help me explain how to get this result? thanks! 

[Lore_BI]

hi @miTutorials , thanks for your answer, sorry if i was unclear, i have a linked date table which i use in the slicer. My problem is that i want the 12 last months based on the slicer, not neceseraly the last 12 dates from now. so if i select january, it should show january last year till january this year. do you know how to get this result? thank you

[miTutorials · Accepted solution]

Check out this tutorial - Hope it helps.

Display Last 6 Months based on the Slicer Selection | PowerBI Tutorial for Beginners | MiTutorials (...

[Lore_BI]

Exactly what i needed, thanks! 

[miTutorials]

Can you create a Calendar table and use the date field in the filter and use the filter type 'Relative' and is in the last 12 months like the below screenshot.