Line y-axis in Line and Stacked column chart

[Irehd]

Hello Everyone,

Does anyone know how to resolve the issue I'm encountering? I have a Power BI chart with multiple columns, and I'm trying to replicate it in the Excel file shown in the attached photo. How can I ensure that the two lines are correctly placed, matching the positioning in the Excel reference? Please note that the data in these two columns is correct, but they are not aligning properly in the chart. Also, does anyone know how to replicate the shaded area in Excel like shown in the reference? When I try to shade the area in Power BI, it extends all the way down, unlike the Excel version.

Excel Reference:

Power BI Chart:

Thank you!

[v-priyankata]

Hi @Irehd , Did your issue get resolved? Did you raise a support ticket? Please let me know.

If solution was helpful, please mark it as Accept Answer and click Yes to confirm.

Feel free to let us know if you have any further questions—we’re here to help!

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-priyankata]

Hi @Irehd 

Awe haven’t heard back from you in a long while, we’re closing this thread. For any further discussions or questions, please start a new post in the Microsoft Fabric Community Forum — we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

[Irehd]

Hi @AllisonKennedy. Could we connect on MS Teams? I followed the steps you suggested, but it still isn't working. Perhaps you could assist me further if we connect on MS Teams.

[AllisonKennedy]

@Irehd it's a pretty crazy time of year, so I don't really have any availability at the moment. Can you share screenshots of what you've done and what's still not working? or sample file?

[Irehd]

Hi @AllisonKennedy . Please check the file at this link.

https://drive.google.com/file/d/1drI20yqrHOmZVK6h5wpahl0GrYu5Dwl3/view?usp=sharing 

[v-priyankata]

Hi @Irehd,
We are unable to access the data you provided. Could you please share the PBIX file and clarify your exact query? This will help us assist you more effectively.

[Irehd]

Hi @v-priyankata , Could you please check this link to see if you can access it? My query is how I can replicate the same chart shown in the Excel reference in my post using Power BI.

https://drive.google.com/drive/folders/1deViMvjhA7U72rOkk2XrRIOauUo0RRWU?usp=sharing

[v-priyankata]

Excel does not have a dedicated secondary axis feature like Power BI. In Power BI, there are two axes: the primary Y-axis and the secondary Y-axis. When data is distributed across both axes, the positioning of lines may differ from the Excel output. To replicate the Excel output accurately, all fields should be placed on the primary Y-axis. To do this, turn off the secondary Y-axis in Power BI. Navigate to the Format Visual pane, select the Secondary Y-axis, and turn it off. This should help align the data correctly.

[Irehd]

Hi @v-priyankata , I disabled the secondary y-axis, but the data still didn't align correctly.

[v-priyankata · Accepted solution]

Please raise a support ticket for this issue and include all the relevant details, along with the PBIX file. Once the ticket is raised, share the ticket details here for reference.

[AllisonKennedy]

@Irehd There is a secondary axis on the Power BI version - you need to make sure that you have set the formatting for the chart to use a shared axis or turn off the secondary y-axis. 

Note, I find that the column line chart has a bug and doesn't always honor this setting even when you set it, so if you're finding that it is reverting back to using the secondary axis you're not alone, if you do find it's an issue report it (I haven't seen this issue for a few years, so maybe it has been resolved, but I don't use this visual often because of it)