Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Y-Axis Alignment Issue in Line and Stacked Column Chart

Hi everyone,   I'm using a Line and Stacked Column Chart in Power BI, and I want to ensure that the primary and secondary Y-axes are always visually aligned, even when filters (like different asset...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi Anonymous 


    Welcome to the Microsoft Fabric Community Forum. Also , thank you rajendraongole1 for your prompt response.

    Currently, Power BI does not offer dynamic synchronization of primary and secondary Y-axes in combo charts like the Line and Stacked Column Chart. However, you can simulate axis alignment using DAX. To do this, calculate a shared maximum value for both the primary and secondary measures using functions like MAXX over ALLSELECTED. Apply this shared value through transparent dummy measures on each axis, ensuring uniform scaling regardless of the filters applied.

     

    For reference: Combo chart in Power BI - Power BI | Microsoft Learn

     

     

    If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.

    Thank you for being part of Fabric Community Forum.

    Regards,
    Karpurapu D,
    Microsoft Fabric Community Support Team.

     

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

Hi Anonymous 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.