topic Re: Y axis Constant Line in DAX Commands and Tips

Y axis Constant Line

Anonymous — Sun, 07 Jul 2024 04:57:45 GMT

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 assist.

Re: Y axis Constant Line

Jihwan_Kim — Sun, 07 Jul 2024 05:23:19 GMT

Hi,

One of ways is to create a measure for the constant line.

I do not know how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Re: Y axis Constant Line

Anonymous — Sun, 07 Jul 2024 05:49:49 GMT

Hi Kim,

Thank you for the quick reply.
Is the same possible for the following dataset.

The chart can be done in excel. But in power bi this constant line is seemed to be a little tough. For the time being I can use error bar for the sake of visualization purpose only. Please check with the following data...Thank you.

Re: Y axis Constant Line

Anonymous — Tue, 06 Aug 2024 07:16:54 GMT

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.