Show line above columns in chart

[ChristophEmrich]

Hi everyone,

I have a "Line and stacked Column Chart" and I'd like to see the line always being above the columns. The columns present a value in [units], the line a value in [%]. So the column values are much higher than the line values.

I have switched on "Show Secondary" on the Y-Axis and right now, the line goes straigt through the columns. If the chart was static, I would just set the End value of the Y-Axis a bit higher than the greatest number in the data. I tried that and it worked but it doesn't work as soon as filters are being used and the greateast number values change.

Is there a way to alwawys display the line significantly above the columns?

[dax]

Hi ChristophEmrich,

I think your requirement can’t be achieved currently. As I know, the data show based on value, although you set secondary, the secondary y-axis will set its aixs based on value

Or only when the line value is  more than bar value, then it will show above bar chart.

I suggest you could submit this requirement in power-bi-ideas.

Best Regards,

Zoe Zhi

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