Forum Discussion
Rolling 12 Month Column Chart - How To Have Months In Order
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
6 Replies
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.
Hi,
I cannot see any problem in the first chart. I see months from Jan 23 - Dec 23. What exactly is the issue?
Hi Ashish_Mathur if I extend the range from Jan 23 to Janu 24, it pulls the data to Jan 23.
Drag Year as well to the X-axis. Ensure that year and Month are both from the Calendar Table.
