Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Line & Cluster Column Chart - How to make Line Y Axis & Column Y Axis exactly same

Hello All,

 

We have a requirement to show Sales progress with Minimum & Expected %. We are using Line & Cluster Column Chart to show Sales Progress in Column bar and Minimum % & Expected % using lines. Below is the data & Chart:

 

Data:

 

 

Chart:

 

 

Issue:: Line Y Axis & Column Y Axis are not alighed. Our requirement is that both should be exactly same. In the above chart, you can Minimum % Line is showing 75% but as per column, it is below 50 %. How to make both Y AXIS identical.

 

Thanks,

PBI V2

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Firstly, ensure that your dataset inclueds the necessary columns for the line and clutered column chart. You should have a category column, a column for the line series, and one or more columns for the clustered columns. After that in pbi desktop go to visualisation pen and drag the fileds like to axis section, and drag the column series field to the column values. Drag the line series field to the Line values. Click on the line chart and go to the format under the y axis option, you should see settings called Y-axis and make that option on. This will synchronise the Line Y-axis with column the Y-axis after that you can further format and customize the chart as needed, such as changing colors, labels, titels to match you requirement. Verify that the line Y-axis and column Y-axis are now exactly the same.