Forum Discussion
Y-Axis Alignment Issue in Line and Stacked Column Chart
- 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.
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.