cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jhwon Frequent Visitor
Frequent Visitor

Can I use two X axis in a line chart?

Hi, I have a data with Closed Week and Transmitted Week columns. (see below)

Capture.PNG

 

But can't get what I want using a line graph due to the blank cells in Closed by WK, week gaps in the two and two columns.

As you may noticed, the numbers are not correct.

 

In week 2019-4, 4 new ones issued and 0 closed, but in the graph below, it shows 2 closed.

In week 2019-5, 1 issued and 2 closed, but only one closed in the graph. I believe this is because of the Axis.

 

If I switch the Axis to "Closed by WK", same error occurs and I cannot integrate two X axis.

 

Capture1.PNGCapture2.PNG

1. Do you think I need to change my excel data first? If there is a blank cell in a column, then it's not feasible?

 

2. If I need to use only one column for Axis, how could I combine the week values in one column from the two?

 

Thank you for your reply in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Can I use two X axis in a line chart?

Hi @jhwon,

 

Nope, line chart not support dynamic switch axis fields.


In my opinion, I'd like to suggest you take a look at following blog about dynamic attribute field based on slicer.

Dynamic Attributes In A Power BI Report

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: Can I use two X axis in a line chart?

Hi @jhwon,

 

Nope, line chart not support dynamic switch axis fields.


In my opinion, I'd like to suggest you take a look at following blog about dynamic attribute field based on slicer.

Dynamic Attributes In A Power BI Report

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |