Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Arrange stacked chart by month

Hello,

 

I have live dataset showing onto a stacked chart. The thing is it is arranged by alpha. not by month, I can't see how I can change this? any ideas please?

 

Need Help

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    You must have a Calendar Table and build a relationship from the Date column of your Data Table to the Date column of your Calendar Table.  In the Calendar Table, create the following calculated column formulas

    Year = Year(Calendar[Date])

    Month Number = Month(Calendar[Date])

    Month Name = FORMAT(Calendar[Date],"mmmm")

    Click on any cell in the Month Name column and click on Sort By > Month Number.

    To your visual, drag Year and Month from the Calendar Table.

    Hope this helps.