Custom Legend grouping color change

[Pradeep_757]

Hi Power BI Experts,

I am new to Power BI

I have one requirement, which is one dimension that is no. of days field and one measure that is average of amount field, and one legend that is account number field as of now line chart looks good, but here I want differentiate account numbers colors based on region.

This requirement needs fullfill in Power BI Line chart.

Please help me, thanks in advance.

Expected Output. 

@Amit @pavan

Regards

Pradeep

[amitchandak]

@Pradeep_757 , Not very clear to me. But you can have legend or multiple measures, not both

[Pradeep_757]

Can we have multiple legends in Power BI line chart.

[Anonymous · Accepted solution]

Hi @Pradeep_757 ,

Based on my research and testing, the default line chart currently only supports one field on the Legend option of the line chart visual. Here's a similar idea shared on Power BI Ideas where you can vote and add your comments to improve Power BI's improvements to this feature.

Line Chart with multiple values fields and legends

And could you please provide some sample data(exclude sensitive data) and your final expected result? Later we can check if there is any workaround or alternative to achieve it. Thank you.

Best Regards