line chart invert range parameter can not be set for second Y axis

Hi,

At the moment, this isn't supported in the native Power BI Line chart.

The Invert range setting applies to the entire visual's axis configuration, so when you enable it, it affects both the primary and secondary Y-axes. There isn't an option to invert only the primary Y-axis while leaving the secondary Y-axis unchanged.

A few possible workarounds are:

• Use two separate line charts (one for each measure) and overlay or align them so they appear as a single visual.
• Transform one of the measures (e.g., multiply by -1) if it makes sense for your scenario, then adjust the axis labels accordingly.
• Consider using a custom visual from AppSource if independent axis inversion is a required feature.

Unfortunately, there is currently no built-in setting to control the invert range independently for the primary and secondary Y-axes.

If this functionality is important for your use case, I'd recommend submitting it as an idea on the Microsoft Fabric Ideas portal, as it would be a valuable enhancement to the Line chart visual.

Hope this helps!

Thanks!

Hi kadirkkkk2 

Technically, you could create another measure by multiplying the original measure by -1:

Inverted Measure = -1*[Original Measure]

However, this does not truly invert only the axis. It changes the actual values to negative numbers, which can also affect the axis labels, data labels, tooltips, and exported data.

From a UX perspective, I would not recommend this approach. A dual-axis chart already requires users to interpret two independent scales. Reversing one of those axes makes the visual even more difficult to understand, because the same upward or downward direction represents opposite meanings for the two measures.

If the purpose is to compare the trends, I would recommend using two aligned line charts or small multiples with the same time axis, preferably positioned one above the other. This provides a much clearer and less misleading comparison.

An inverted axis can be appropriate in specific cases, such as rankings where 1 should appear at the top, but combining an inverted axis with a secondary Y-axis is generally not a good design choice.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

This behavior is currently a limitation of the native Power BI Line chart.

When a line chart uses both:

• Primary Y-axis

• Secondary Y-axis

the Invert range setting is applied at the visual level rather than independently for each axis. Therefore, changing the range inversion for one axis also affects the secondary axis.

Currently, Power BI does not provide a separate Invert range option for:

• Primary Y-axis only

• Secondary Y-axis only

Possible workarounds

1. Use separate visuals
The most straightforward workaround is to split the chart into two visuals:

• One line chart with the inverted Y-axis.

• Another line chart for the secondary metric.

You can align them using:

• Same X-axis

• Same size and position

• Transparent backgrounds

2. Transform the measure
If your goal is only to visually reverse one measure, you can create a new measure:

Reversed Measure =
-1 * [Original Measure]

Then format the axis labels accordingly.

This allows the visual to behave like an inverted axis without changing the secondary axis settings.

3. Use a custom visual
Custom visuals (such as Deneb) provide more control over:

• Independent axis configuration

• Scale direction

• Multiple axes

This may be a better approach if the requirement is for a production dashboard with complex visualization needs.

Recommendation

For a simple business report, transforming the measure is usually the easiest workaround. For advanced analytical visuals where independent axis control is required, a custom visual is the better option.

It would also be useful to share your scenario (for example, whether you are showing variance, temperature, stock levels, etc.), because there may be a better visualization design than using an inverted secondary axis.

For more information:

• Line charts in Power BI: https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-line-chart

• Create measures in Power BI: https://learn.microsoft.com/power-bi/transform-model/desktop-measures

💡 Helpful? Give a Kudos 👍 — keep the community growing.

✅ Solved your issue? Mark this as the Accepted Solution ✔️

Best regards, Prince Singh | Data Science & Microsoft Fabric Enthusiast

You cannot independently invert only the primary Y-axis while leaving the secondary Y-axis normal in the standard line chart.

When you enable Invert range, Power BI applies that behavior to the visual’s Y-axis scaling behavior in a way that affects both axes together.

could you pls provide some sample data and expected output. let's see if we have any workaround for that?

Hi kadirkkkk2,

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. 

Thank you.

Hi kadirkkkk2,

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you