Forum Discussion

Irehd's avatar
Irehd
Frequent Visitor
1 year ago
Solved

Line y-axis in Line and Stacked column chart

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!

 

Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

11 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    1 year ago

    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)

  • Irehd's avatar
    Irehd
    Frequent Visitor
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.