Dual Line in y axis without Legend

[Thennarasu_R]

Hi Team,
I need a help from your side .
During I creating Line i'm facing issues . I Have one segment column in line chart want added the two measures in Y axis . one more measure in Secondary Y axis. When i put two measure in Y axis only one measure working another measure show the straight line its filter based on measures values
How require this  Querry.

 @Arul Kindly help this scenarios Anna. i tried not get it anna.

Thanks,
Thennarasu

[Arul · Accepted solution]

@Thennarasu_R ,

If you see the Sum of Profit numbers it is very huge when compared to Sum of Sale Price. That is the reason you are seeing straight line for Sum of Sale Price since it is smaller number compared to Sum of Profit numbers. If you have the Sum of Sale Price numbers also very high similar to that of Sum of Profit numbers then you may see some variance in the Sum of Sale Price line as well. Please see the data in the attached image.

Thanks,

Arul

[pratyashasamal]

Hi @Thennarasu_R ,
Put the Sum of Profit to Secondary Y axis as shown below . Hopefully you will achieve the desired result.

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[Thennarasu_R]

Hi @pratyashasamal 

Totally i have 3 measure :
2 measure in Y axis 
1 Measure in Secondary Y axis .
so this also work fine . i want add one measure in y axis . If Add one more measure in line chart Then it will show Straight line . That querie How to Require .

Can you help Me this one ?



Thanks,
Thennarasu