Show last 6 months of values from selected month

[Anonymous]

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?

[v-cherch-msft · Accepted solution]

Hi @Anonymous

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

Regards,

Cherie