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 Powe...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

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

    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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you for your assistance!

     

    Really appreciate this.

     

    Regards,

    Bona

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    You are welcome.

  • MathiasObton's avatar
    MathiasObton
    New Member
    2 years ago

    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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

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