Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Clustered column chart issue with double X axis values

Hi,

 

The both axis in my clustered column chart don't work and I don't know why.

 

First, I create 2 separate clustered column charts, one for COM, one for RESP (left part).

Then, I tried to get one with both data but, when I add 2 axis (COM and RESP), always the first one is taken into account but not the second one. I guess it is normal but I don't know how to get round it. Somebody has an idea ?

 

 

 

For information, here is a part of the content of the table Sheet1 (very simple).

 

 

Regards,

CR

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi jthomson,

     

    You're right. I tried to proceed like this and it finally worked!

     

    I created a new table with all the YEAR - MONTH combinaison and I count the number of COM and RESP in this table.

     

     

    Then I drag and drop appropriate columns in the clustered column chart as follows:

     

     

    So cool...

     

    Regards,

    CR

3 Replies

  • jthomson's avatar
    jthomson
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Easier to make a date table, or at least a table with all the relevant months listed, and link to your two tables from that. Then use the new table's column as your x axis

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi jthomson,

       

      You're right. I tried to proceed like this and it finally worked!

       

      I created a new table with all the YEAR - MONTH combinaison and I count the number of COM and RESP in this table.

       

       

      Then I drag and drop appropriate columns in the clustered column chart as follows:

       

       

      So cool...

       

      Regards,

      CR

  • Taran298's avatar
    Taran298
    Regular Visitor
    3 years ago

    Hi, 

    I am trying to show two parameters on x axis region and deposits and y axis has one parameter how I can make graph like that in Power BI Desktop.