Multiple lines in single visual

[Anonymous]

Hello Everyone,

Is there any possibility to use double axis to show multiple lines in single visual?  I am using the visual "Line and Stacked Column Chart with Table?

If you can see the 3rd image it's not showing what exactly needed based on 1st and 2nd Images. I need the lines like 1st and 2nd image in single visual. Can anyone please help me with your ideas. 

Below are the measures iam using 

Bottles Target % = DIVIDE([Bottles Produced], [Bottles Production Target])

Bottles Produced = sum(V_PBI_DTA_SAM_Daily[PEHQTYEach])

Bottles Production Target = sum(V_PBI_DTA_SAM_Daily[CALC_BottleTarget])

CALC_BottleTarget = [GPH] * 'V_PBI_DTA_SAM_Daily'[CALC_NominalSpeed] * 'V_PBI_DTA_SAM_Daily'[CALC_Target]

Regards,

Venkat

[v-rzhou-msft · Accepted solution]

Hi @Anonymous ,

According to your statement, I think your problem is that currently there are two lines in your visual3, one line contains large numbers more than thousands, another line contains percentage format number which are quite small. The Y axis of line is large. So the second line doesn't look obvious, like a straight line. 

Here I suggest you don't add these two measures in line field at the same time. You can add [Bottles Target %] in Tooltips.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.