cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ravik4934 Member
Member

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

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:

line break.JPG

 

 

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
v-jiascu-msft Super Contributor
Super Contributor

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

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.

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

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jiascu-msft Super Contributor
Super Contributor

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

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Highlighted
v-jiascu-msft Super Contributor
Super Contributor

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

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.

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

 

Best Regards,
Dale

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

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

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 Super Contributor
Super Contributor

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

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

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

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 115 members 1,688 guests
Please welcome our newest community members: