Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
7 years ago

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?

Need Help

2 Replies

    • DebbieE's avatar
      DebbieE
      Icon for Community Champion rankCommunity Champion
      7 years ago

      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.