How to replicate information represented as a table in a Line Chart?

[Anonymous]

I have created a table in PowerBI as per picture below.

Table

Now I am trying to display the same information as a Line Chart.

Date -> X-axis

ActualGnrtn -> Y-Axis

PASAAVAILABILITY -> Y-Axis

Attribute -> Legend

However, after I populate Axis with Date and Values with ActualGnrtn and PASAAVAILABILITY in the Line Chart, PowerBI won't let me alocate Attribute to Legend.

If I include a Slicer for Attribute, I can only get the sum of Values when I select more than one Attribute.

How do I replicate the table's data as a line chart?

[amitchandak · Accepted solution]

@Anonymous , As of now you can not have two measures with legend. The workaround is, if legends are limited create that many measures.

Or check for custom visual https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

The Line chart is not supported to have both legend and multiple values.

You could consider to create multiple measure instead of using legend.

Best Regards,

Jay

[amitchandak · Accepted solution]

@Anonymous , As of now you can not have two measures with legend. The workaround is, if legends are limited create that many measures.

Or check for custom visual https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals