Creating a Y-Axis Constant Line in a Bar & Line Chart

[Anonymous]

Hello everyone, nice to meet you.

I am new to Power BI, and I am currently in need of your assistance for a problem that I want to solve.

Here is a picture of a chart that I have made in Power BI. This line chart depicts the effective tax rate per year, calculated by dividing income tax with the net profit before tax (information visualised with bar charts).

ETR Chart

I want to add a constant Y-Axis line in this chart to show the applicable tax rate based on the prevailing regulation. However, when I checked in the Analytics menu, there is no option to create one.

Really appreciate if anyone has a solution for this.

Thank you!

Bona

[v-henryk-mstf]

Hi @Anonymous ,

I'm afraid this couldn't be achieved because the value of constant line is determined by constant value. For the visual like Line and clustered column chart,It is not possible to add a constant Y-Axis line.

On the other hand, I think that add a constant Y-Axis line to show the applicable tax rate based on the prevailing regulation in such a visual does not seem to make much sense. Consider other visual objects to meet your requirements.

Best Regards,
Henry

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

[Anonymous]

Hi Henry,

No problems.

Thank you for the assistance and sorry for bothering.

Regards,

Bona

[v-henryk-mstf]

Hi @Anonymous ,

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[v-henryk-mstf]

Hi @Anonymous ,

As @Ashish_Mathur  said, the link provided does not open directly. Can you switch to another sharing method to facilitate me to answer you as soon as possible.

Best Regards,
Henry

[Anonymous]

Sorry, please use this link instead.

https://drive.google.com/drive/folders/1fea8NWbBx4C-_FThHZdm4ROAGKqFJLSJ?usp=sharing

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Anonymous]

https://drive.google.com/file/d/1zXwuW6i1rs_fvYjrTgIFPCCg4og0K82s/view?usp=sharing

Please use the link above.

[Ashish_Mathur]

I get an access denied message.

[Anonymous]

May I send directly to your email?

[Ashish_Mathur]

No.  I would not like to share my e-mail address.  Please share the download link.  Thank you.

[Anonymous]

Power BI file - https://www.dropbox.com/scl/fi/3s10ajxrmw338a513m1gz/ETR-data.xlsx?dl=0&rlkey=w9jscqcbo4pght8bs7cvmf...

Excel file - https://www.dropbox.com/s/04mhgqrhtaudkpc/ETR.pbix?dl=0

Can you access those files?

[Ashish_Mathur]

Hi,

I added a measure to show a constant line of 37%

[Anonymous]

Hello Ashish,

Thank you for the response.

I noticed that you used a measure there. Is it possible to make the Y-Axis constant line based on a user input value? For example I want to set the constant line at 22% or 25% like that.

Regards,

Bona

[Ashish_Mathur]

You are welcome.  You can create a single column disconnected table.  Create a slicer and selected any percentage value there.  Use the SELECTEDVALUE(0 function to harvest the percentage value selected in the slicer.  Drag that measure to the visual.

[Anonymous]

Can you show me the screenshot of the formula?

I am new to Power BI and I don't know how it works.

Regards,

Bona

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[MathiasObton]

Hello sir, 

You have solved excatly what I need but I cannot access the link. Can you share it with me in some other way?

Best regards,

Mathias

[Ashish_Mathur]

Hi,

I do not have that file.  Share some data, explain the question and show the expected result.

[Anonymous]

Thank you for your assistance!

Really appreciate this.

Regards,

Bona

[Ashish_Mathur]

You are welcome.