Forum Discussion

LucienF38's avatar
LucienF38
Helper I
7 years ago
Solved

Double grouping X axis - Year/month - visualization

Dear Community,

 

I would like to make a 100% stacked column chart with a double X axis Year/month as you can see below on the pic. By using the same method than in excel it doesnt work and put only year and/or only months.

 

Do you have any idea on how to solve this issue ?

 

Thanks :)

  • Anonymous's avatar
    Anonymous
    7 years ago

    You need to change the Concatenate label setting on the X-Axis.

     

    Then ensure you have expanded the hierarchy on the visual

    Some times you will also need to correct the sort order

     

  • Anonymous's avatar
    Anonymous
    7 years ago

    Its a good modeling practice to have a seperate date dimension in your data model.  This table should include a rich set of date fields that you can use in your reporting.  One of the features would be to add an additional column that define the sort order of your months e.g. 1 = Jan etc...  You then need to assign this sort order field to the month label to ensure they are sorted in the correct way.

     

    Hope this makes sense.

     

     

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    You need to change the Concatenate label setting on the X-Axis.

     

    Then ensure you have expanded the hierarchy on the visual

    Some times you will also need to correct the sort order

     

    • LucienF38's avatar
      LucienF38
      Helper I

      Hello Anonymous ,

       

      Thanks ! your answer was very helpful. Just a question, I have now an issue of sorting on X axis. I would like 2018 on the left hand side and the months increasing from left to the right. Can you help on this ? 

       

      Thanks :) 

       

      • LucienF38's avatar
        LucienF38
        Helper I

        I am able by clicking "sort ascending" to have 2018 on the left and 2019 on the right but the months are not sorted as you can see below :