Can I use two X axis in a line chart?

[jhwon]

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

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.

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.

[v-shex-msft · Accepted solution]

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