Rolling 12 Month Column Chart - How To Have Months In Order

[ME_1976]

Hi Folks,

A newbie here in the world of Power Bi. 

The forum was super helpful with my first question, putting it into easy understanable languae for someone who is just getting to grips with PB. So, I thought it would be worth seeking advice via here on my next problem. 

I have a clustered column chart, with month, in/out SLA and average days. 

This works on a slicer, to focus on the months, or to provide a chart showing rolling months. However, when I set it to Feb 23 to Jan 24, it puts Jan 24 at the start of the chart when I'd want it on the righthand side in order. This happens if I select Feb 22 to Feb 23 etc. If that makes sense.  I'd like the chart to show rolling month, in order so it would be Jan23 to Jan 24, Feb23 to Feb 24 and so on when I select the range using the slicer with the eldest month on the left and the most recent on the right. If that makes sense. Is there a way of doing this? I've included screen grabs of my data to help explain the approach

As mentioned I'm quite new to this, so appreciate any assistance and even more so that's not jargon heavy 😊

Thanking you in advance. 

This is the chart, with the slicer to select the month range. 

The information is laid out like this in the table view

Date table view

Model view showing the dates connected

Excel spreadsheet with the dates used

Excel performance data

[Ashish_Mathur]

Hi,

I cannot see any problem in the first chart.  I see months from Jan 23 - Dec 23.  What exactly is the issue?

[ME_1976]

Hi @Ashish_Mathur if I extend the range from Jan 23 to Janu 24, it pulls the data to Jan 23.

[Ashish_Mathur]

Drag Year as well to the X-axis.  Ensure that year and Month are both from the Calendar Table.

[ME_1976]

Hi @Ashish_Mathur this doesn't work, as it still puts Jan 23 and Jan 24 next to each other. Then when I populate Feb 24 that appears on the righthand side, next to Jan 24 and Jan 23 no longer visable. 

I think the solution may well be what @danextian has suggested (happy for someone to suggest an alternative), and I'm trying to understand that better as its all very new to me and to an extent learning as I go along. 

[danextian]

Hi @ME_1976 ,

You would need a disconnected dates table to do this. Attached is a sample pbix you can play around with.

[ME_1976]

Hi @danextian I'm trying to follow the example, and to be honest as a newbie to Power Bi struggling to get my head around the coding element. I can follow you example, but then putting it in play on my own dashboard I'm struggling working it out. Think I'm struggling with the Rolling Values coding, as I want to show in SLA, OUT SLA and average days (stacked column). So trying get my head around the difference from your code and what I should type in mine. If that makes sense. 

Apologies if I've not used the correct terminology, as I'm quite new to this. 

Thanking you in advance.