Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
@Pradeep_757 , Not very clear to me. But you can have legend or multiple measures, not both
Can we have multiple legends in Power BI line chart.
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