In line chart how to use two clumns or more then columns in y-axis

[shivendrapraja]

Hi all,

I using line chart to visualize my graph i'm plotting data in X-axis and Y-axis and also using legends to show but i want to show two columns in y-axis with legend but i'm not able to show.

Can u guys please help me this if u have any idea. 

[Anonymous]

Hi @shivendrapraja 

In a line chart visual, if you have put a field on Legend, you can put only one field to Y-axis. If you don't have any field on Legend, you can drag more than one fields (columns or measures) to Y-axis. This is by design. 

If you want to show lines and columns on the same chart, you can try line and clustered column chart visual. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!