Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Lore_BI
Frequent Visitor

Get last 12 months on linechart

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

Lore_BI_1-1709631095612.png

 

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: 

Lore_BI_3-1709631140043.png

 

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

1 ACCEPTED SOLUTION
4 REPLIES 4
Lore_BI
Frequent Visitor

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

Exactly what i needed, thanks! 

miTutorials
Super User
Super User

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.

 

miTutorials_0-1709631667876.png

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!