Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Line Chart Question

I'm trying to find a way to get a total line to display in a line chart and I think I've stumbled upon something and hoping someone can confirm this for me.  It appears that the line chart visualization is designed so that you can set either the Secondary y-axis OR the Legend but you cannot set both of these properties at the same time.  Is my observation correct or am I missing something?

 

Thanks,

 

Scott

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @Anonymous ;

Yes ,here cannot set both of these properties at the same time.
Since the classification is to divide a polyline into multiple polylines according to Legend, but Secondary y-axis means that there are 2 lines, which currently does not support simultaneous, if you want to add auxiliary lines, you can add another line to the classification.
Or If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community


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

View solution in original post

1 REPLY 1
v-yalanwu-msft
Community Support
Community Support

Hi, @Anonymous ;

Yes ,here cannot set both of these properties at the same time.
Since the classification is to divide a polyline into multiple polylines according to Legend, but Secondary y-axis means that there are 2 lines, which currently does not support simultaneous, if you want to add auxiliary lines, you can add another line to the classification.
Or If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community


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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.