Line chart

[Alex_0201]

Hi, how can one build a regular line chart from two measures? The X axis field in the line chart doesn't accept one of these measures.

[harshnathani]

Hi @Alex_0201 ,

You cannot use Measures as an AXIS or a Legend.

Regards,

Harsh Nathani

[Alex_0201]

Hi @harshnathani Do you know if I could instead use columns (in the report mode) as Axis?

[harshnathani]

HI @Alex_0201 ,

You can use Columns as AXIS.

But can you share what you are trying to acheive and some sample data 

Thanks,

HN

[amitchandak]

@Alex_0201 , Line chart can take two measures if you not using the legend. Are you using legend ?

[Alex_0201]

Hi @amitchandak no, neither Legend nor Axis accept the measure. I can only add this measure into Values, Secondary Values and Tooltips.

[amitchandak]

@Alex_0201 , I am able to add the values I want :

[Alex_0201]

@amitchandak  Is your Date a measure?...I need to add a measure in the Axis field.

[amitchandak]

@Alex_0201 , No date does not measure. Can you explain the need of date measure on axis

[v-yiruan-msft]

Hi @Alex_0201 ,

Currently measure can't be used in Axis fields or Legend fields of line chart visual. Please check if the workarounds in the following threads can help you.

Use Measure as Axis in visual

How to use a measure as an axis in Power BI

Dynamically change chart axis in Power BI

Best Regards

Rena

[Alex_0201]

Hi @v-yiruan-msft Do you know if I could instead use columns (in the report mode) as Axis?

[v-yiruan-msft]

Hi @Alex_0201 ,

Could you please provide some sample data, expected result and the formulas of measure which you want to use in X Axis of line chart? It is better if you can explain the calculation logic of this measure. We will check if it can be created as calculated column, then use the new calculated column in line chart. Thank you.

Best Regards

Rena

[Alex_0201]

hi @v-yiruan-msft Thanks for your replies. I've sent you pm (Sent: ‎07-15-2020 03:13 AM)