cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DebbieE Member
Member

Column chart using month from date hierarchy Not ordering properly when year changes

This looks like one that keeps cropping up. Ive seen videos on how to do this with a column called Month but Im specifically using the month from the date hierarchy, You would think that because its in the date hierarchy it would automatically sort correctly

 

I have a column chart and its currently ordered January, August September October November December

 

of course I need it ordering by August September October November December January. It only allows you to sort by one field Month.

 

And you cant add a sort by column to Month because its in the hierarchy

 

How do I get the Month part of the date hierarchy to sort by Year and Month?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Column chart using month from date hierarchy Not ordering properly when year changes

Hi @DebbieE,

 

Please refer to my reply in this similar thread.

Making the x-axis labels into a timeline

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DebbieE Member
Member

Re: Column chart using month from date hierarchy Not ordering properly when year changes

I tried that and it didnt work

 

1. You cant apply a sort order to Month in the hierarchy

2. You can apply a sort order to date but this doesnt seem to apply to Month when you get to that level

 

I have done a workaround where I created a string of 201901 201812 and I have had to add it into the tooltip so I can use it as a sort for everything. Its not great thought because I dont really want that value in the tooltip but If its not there I cant sort on it.