Line and Clustered culomn chart with same scale for the two Y-axes

[Anonymous]

Hello,

I have following table:

YEAR_QUARTER	YEAR_QUARTER_ORDER	PERCENTAGE_QUARTER_EAST	PERCENTAGE_QUARTER_WEST	PERCENTAGE_QUARTER_TOTAL	PERCENTAGE_YEAR_EAST	PERCENTAGE_YEAR_WEST	PERCENTAGE_YEAR_TOTAL
2019 Q1	20191	97,56	95,87	96,46	97,56	95,87	96,46
2019 Q2	20192	99,39	100,74	100,27	98,48	98,31	98,37
2019 Q3	20193	100,18	98,74	99,24	98,49	97,95	98,14
2019 Q4	20194	95,90	94,36	94,90	97,32	98,37	98,00
2020 Q1	20201	97,50	98,86	98,38	97,50	98,86	98,38
2020 Q2	20202	95,70	101,50	99,47	96,60	100,18	98,93

The column YEAR_QUARTER is sorted by YEAR_QUARTER_ORDER

I want to make a Line and Clustered culomn chart:

Shared axis: YEAR_QUARTER
Column values:    Sum of PERCENTAGE_YEAR_TOTAL

          Y-axis (Column) : Start: 90, End: 105

Line values:         Sum of PERCENTAGE_YEAR_EAST

                           Sum of PERCENTAGE_YEAR_WEST

The result is:

The scale of the Y-axis for the Lines is NOT the same as the  scale of the Y-axis for the Columns.

Why is this?

Can I make the Y-axis for the Lines the same as the  scale of the Y-axis for the Columns?

Thanks

R.W.

[amitchandak]

@Anonymous , @parry2k  has already suggested the option.  In this link, they have used the same axis for both lines and bars.  see if this can help https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

[parry2k · Accepted solution]

@Anonymous on format pane, turn on align zero for 2nd axis.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡