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

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.