Y-Axis Alignment Issue in Line and Stacked Column Chart

[mladird]

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 assets) are applied.

I found a temporary workaround by manually setting minimum and maximum values for both axes.
The minimum value works fine, but the maximum value is problematic:

• For some assets, it's way too high, making the chart hard to read.
• For others, it's just right.

The issue is: if I leave the maximum values on auto (blank), the two Y-axes are never aligned, which I want to avoid.

My question:
Is there a way to automatically synchronize the Y-axes (primary and secondary) so they stay aligned, while still adapting dynamically to the filtered data?

Thanks in advance for any ideas or solutions!

[v-karpurapud]

Hi @mladird 

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.

[v-karpurapud]

Hi @mladird 

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank You!

[v-karpurapud]

Hi @mladird 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-karpurapud · Accepted solution]

Hi @mladird 

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]

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. 

 

 

@mladird