Is there a third axis for line and stacked column chart

[naivecalf]

I am trying to build a report to show product volumn and yield, and also KPI. the volumn bar uses first axis which is 0 - 2000, and the yield line using second one which is 70% - 100%, how can I show a KPI line which is 1500. thanks.

[naivecalf]

@ValtteriN thanks, but I need to show volumn bar as well, then the KPI can not be together with yield.

[ValtteriN]

@naivecalf 

You can still place the column bar values here. I just used two line measures in my example

[naivecalf]

Hi, I put vol and yield, this is good.

how ever, it changed when I tried to put KPI, since the KPI is 1200, it is using same axis with yield. not sure if there is something wrong.

[ValtteriN · Accepted solution]

Try switching vol and yield around. So use yield for columns and vol for line

[ValtteriN]

Hi,

There isn't a direct option for a constant line like for example in line chart, but you can create a measure like this: 

Constant line = 1500

Then just use this in the visual:

Ping me with @ IF you have questions.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/