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

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

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