Forum Discussion
Line y-axis in Line and Stacked column chart
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.
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.
Hi Anonymous , 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
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.
Hi Anonymous , I disabled the secondary y-axis, but the data still didn't align correctly.
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.