Slice months automatically

[Anonymous]

Hi.

I have a calendar table in my model  and  want that when I select a period in the slicer, it detects the previous 13 months and in the line chart shows me only those months, in this moment I have to select on the slicer the 13 months that I want to see.

Thanks

[Ashish_Mathur]

Hi,

See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.

[lbendlin]

"when I select a period in the slicer" - how do yo then decide what "previous 13 months"  should be?  From the beginning of the period? from the end? or the full last 13 months before your slicer period?