Forum Discussion

cshowe80's avatar
cshowe80
Helper I
9 years ago
Solved

Charts With Month in Order

Greetings,

 

I'm doing a Sales Report and I'm unable to get my bar chart to sort the Months in order. My Slicer is a list of "Sites" and when I select a site I want to see the values for each month over the course of the past 3 years. 

 

In my data I've got a column for:

 

1. Year

2. Month (Text: January, February, March, etc)

3. Month Number (January is 1, February is 2, etc)

 

Everything looks exactly how I want it to with the exception of these months not showing up in chronologic order. How can I solve this? Do I need to make a new measure?

 

Chart

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Need Help
  • Dog's avatar
    Dog
    9 years ago

    sounds like you just need to edit the month column and set the sort by column property to Month Number

     

    then on the graph, select the ellipsis in the top right and set it to sort by Month. you may need to select this twice as I think the first time it sets it to descending order.

2 Replies

  • Dog's avatar
    Dog
    Responsive Resident
    9 years ago

    sounds like you just need to edit the month column and set the sort by column property to Month Number

     

    then on the graph, select the ellipsis in the top right and set it to sort by Month. you may need to select this twice as I think the first time it sets it to descending order.