Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Y axis Constant Line

Is it possible to add a Y axis constant line in a combo chart (line and clustered column). Whenever I am trying to add a constant line I am getting the option of X-axis constant line only. Please ass...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,Jihwan_Kim 

    thanks for your concern about this issue. 

    Your answer is excellent! 

     

    Hi,Anonymous 

    I am glad to help you. 

    According to your description, you want to know why you are trying to add a constant line you are getting the option of X-axis constant line only? 

    If I understand you correctly, then you can refer to my solution. 

     

    I'm sorry to tell you that after my repeated tests, I can't get the results you want in Power BI, because the values of your two line charts are not standardized metrics: one takes the value of the bar chart and the other takes the value of the percentage. 

      

    So I assumed a Measure when testing, which is what I got from the test: 

     

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.


    Best Regards,
    Fen Ling,


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