Forum Discussion

DM_BI's avatar
DM_BI
Icon for Helper III rankHelper III
7 years ago
Solved

Concatenate X axis in clustered column chart

Hello,

 

Is it possible to concatenate the X axis in a clustered column chart ? I can see the funcionality but it doesn't work me. 

 

Thank you,

 

DM

  • DM_BI ,

     

    So your requirement is to create a hierarchy X-axis and concatenate the them, right? I would suggest you to follow the video below:

    https://www.youtube.com/watch?v=9DeAKM4SNJM

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    DM_BI ,

     

    You need to sort the X-axis by column, click ellipse icon on the right-top of cluster column chart and then select "Sort by".

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • DM_BI's avatar
      DM_BI
      Icon for Helper III rankHelper III

      Hi,

       

      Thank you for answer, it works ! Do you know if there is a possibility of showing the name only once instead of for each column ? For exemple write "General" once for the three columns below ?

      Thank you very much for your help.

      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support

        DM_BI ,

         

        So your requirement is to create a hierarchy X-axis and concatenate the them, right? I would suggest you to follow the video below:

        https://www.youtube.com/watch?v=9DeAKM4SNJM

         

        Community Support Team _ Jimmy Tao

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.