cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cshowe80 Regular Visitor
Regular Visitor

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?

 

Capture.JPGChart

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Capture2.JPG

 

Capture3.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Dog Established Member
Established Member

Re: Charts With Month in Order

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 2
Dog Established Member
Established Member

Re: Charts With Month in Order

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.

cshowe80 Regular Visitor
Regular Visitor

Re: Charts With Month in Order

Worked Perfectly!!

 

Thanks!