Forum Discussion
Custom Legend grouping color change
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
Hi Anonymous ,
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
3 Replies
- amitchandak
Super User
Anonymous , Not very clear to me. But you can have legend or multiple measures, not both
Hi Anonymous ,
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
