cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Invert Y-Axis on Line Graph

Dear All, 

I have a Line Graph that I would like to invert the values on y-axis. It is the graph where 1 is the best and the higher the number, the worse the performance of the application is.

As found in other threads, I multiplied the number by (-1) to invert the y-axis but the graph doesn't make any sense if I put the data label as all the numbers are negative. 

Is there a workaround solution for this solution? Is there a way to make the data label positive in the graph

Negative Ranks.PNG

 

Many thanks in advance for your time and support. It is very much appreciated. 

Best regards,

Trang 

13 REPLIES 13
danno Member
Member

Re: Invert Y-Axis on Line Graph

Not as far as I can see.  The only way I could think of would be to convert the values into some kind of relative score where the maximum value is 100% where the score is the closest to zero.  the value would be 0% where the value is the highest out of the set. 

Super User
Super User

Re: Invert Y-Axis on Line Graph

@Anonymous if the graph looks as per your expectation and only issue is with data label, you can turn off data label and create tooltip to show positive value. That might be another workaround






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Re: Invert Y-Axis on Line Graph

Hi @parry2k , thank you very much for your response, do you know how to create the tooltip to show positive value? I am not an expert in DAX so any suggestion would be really great! 

Super User
Super User

Re: Invert Y-Axis on Line Graph

@Anonymous are you open to share pbix file if doesn't contain any sensitive information and I can add the tooltip.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Re: Invert Y-Axis on Line Graph

Hi @parry2k , indeed that our pbix file contains some sensitive information.. do you know if there is another way? otherwise i can try to create a dumbo pbix file? 

Super User
Super User

Re: Invert Y-Axis on Line Graph

@Anonymous i can try to explain it here but if you can create a dummy pbix that will be quick.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Re: Invert Y-Axis on Line Graph

@parry2k actually it might take me quite a while to create the dumbo file Smiley Sad I would really appreciate if you could help me to explain here

Super User
Super User

Re: Invert Y-Axis on Line Graph

@Anonymous understood, here is the link which explains how to create tooltip and on tooltip page you can measure with positive value. It is pretty straight forward.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Re: Invert Y-Axis on Line Graph

@parry2k I haven't seen the link anywhere yet, could you please try to paste it again?

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 182 members 2,000 guests
Please welcome our newest community members: