cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver II
Resolver II

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 ?

 

 

1.png

 

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

 

2.png

 

Regards,

CR

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver II
Resolver II

Re: Clustered column chart issue with double X axis values

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.

 

3.png

 

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

 

4.png

 

So cool...

 

Regards,

CR

View solution in original post

2 REPLIES 2
Highlighted
Super User I
Super User I

Re: Clustered column chart issue with double X axis values

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

Highlighted
Resolver II
Resolver II

Re: Clustered column chart issue with double X axis values

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.

 

3.png

 

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

 

4.png

 

So cool...

 

Regards,

CR

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors