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.

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi   -  you can't dynamically bind the axis range, but you can simulate this behavior via transparent dummy data, Power BI currently does not support auto-synchronization of the axes out-of-the-box. You can calculate a shared max value across both measures using DAX and use that to fix the axis ranges via fields in the visual. But if you're comfortable with custom visuals and want more control, Deneb. Hope it helps.

you can bind axes directly to measures, including this max value too. 

 
 

 

 

 

Anonymous