Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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

Need Help
Tips and Tricks

20 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    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

     

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Henry,

       

      No problems.

       

      Thank you for the assistance and sorry for bothering.

       

      Regards,

      Bona

      • v-henryk-mstf's avatar
        v-henryk-mstf
        Icon for Community Support rankCommunity Support
        4 years ago

        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