How to show on a graph the last 6 months

[rmitsos]

I have a very plain request for which I'm banging my head to find out how to model it. I need to show on a graph the last 6 months (or x months anyway). I use a relative slicer for this reason but when I'm passing from 2017 to 2018 then Jan and Feb are going at the beginning of the graph and not at the end for showing the continuity e.g. Sep-17, Oct-17, Nov-17, Dec-17, Jan-18, Feb-18

I know it's stupid and please forgive me for the noob question,

[v-yulgu-msft]

Hi @rmitsos,

In my test, the Month-Year displayed on X-axis shows correct order. Are "Sep-17", "Oct-17", "Nov-17" mentioned above date type values in your scenario?

Regards,

Yuliana Gu

[rmitsos · Accepted solution]

Thank you very much for your immediate reply. I found out the cause of my 'problem' (actual inability...)

* yes format is correct meaning date

* the actual problem was that I was not using the 'expand level' but the 'next level' of of the graph. Below with the red arrow the correct selection