cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Slice months automatically

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

2 REPLIES 2
Highlighted
Community Champion
Community Champion

Re: Slice months automatically

"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?

Highlighted
Super User IV
Super User IV

Re: Slice months automatically

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors