cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jonimatix_guk Frequent Visitor
Frequent Visitor

Show last 6 months of values from selected month

Hi everyone,

 

I need some assistance to achieve the following.

 

Basically if the user selects 1 specific month from a slicer, ex. July 2018, a chart will show data for Feb 2018 - July 2018. This will allow me to show for example sales for July 2018, but also a trend of the previous 6 months.

 

Any suggestions?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Show last 6 months of values from selected month

Hi @jonimatix_guk

 

You may have a look at this article.Attached the sample file for your reference.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: Show last 6 months of values from selected month

Hi @jonimatix_guk

 

You may have a look at this article.Attached the sample file for your reference.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.