Legend is not allowing when in values section two measures are used

[Anonymous]

Hi Community,

Whenever I am using two or more measures in Values shelf either in "Bar Chart" or "Line Chart". In Legend shelf I am unable to drag any field.

For Sample data I am attaching here the link:

https://drive.google.com/file/d/1MLtUQZpE0T2IpltYY591zwSthfsIhLqw/view?usp=sharing

In one of them, my requirement will get solved if power bi allows that. So please guide me regarding this or any alternative to achieve my requirement. i.e:

As you can see 2 different years having 2 different colors. In axis, I am using week number, in legend I want to use year with two different measure( one thick line, one thin line) as you can see above.

Best Regards,

Ravi

[v-jiascu-msft · Accepted solution]

Hi Ravi,

Please download the workaround in the attachment. It's a limitation for now. I would suggest you vote up these ideas.

line-chart-with-multiple-values-fields-and-legends and two-values-and-legend-on-line-chart.

The workaround is:

1. Pivot the [P1] and [P2] columns.

2. Add a custom column which will be used as a legend.

Best Regards,
Dale

[v-jiascu-msft · Accepted solution]

Hi Ravi,

Please download the workaround in the attachment. It's a limitation for now. I would suggest you vote up these ideas.

line-chart-with-multiple-values-fields-and-legends and two-values-and-legend-on-line-chart.

The workaround is:

1. Pivot the [P1] and [P2] columns.

2. Add a custom column which will be used as a legend.

Best Regards,
Dale

[Anonymous]

Thank you @v-jiascu-msft.

It worked but just 1 conformation I want Dale. As I haven't tested in production yet.

Could you please suggest that it will not affect too much with 10 million records. And I can not use this in some scenario because of the extra custom column as per client requirement. As developing purpose its just did a trick.

For Vote up, ideas, when I clicked to the link warning, popped out page not found.

Best Regards,

Ravi

[v-jiascu-msft · Accepted solution]

Hi Ravi,

I tested the solution with 10.2 million rows and 20 columns. It's done in seconds. I think you can try it in the Production.

The two links are good in my side. Can you right click it can copy the address?

Best Regards,
Dale