Forum Discussion

ME_1976's avatar
ME_1976
Frequent Visitor
2 years ago

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...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

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's avatar
    ME_1976
    Frequent Visitor
    2 years ago

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

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

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

      • ME_1976's avatar
        ME_1976
        Frequent Visitor
        2 years ago

        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.