Forum Discussion

DanWMG's avatar
DanWMG
New Member
10 years ago
Solved

Invert Y Axis

Hi All,   I'm wanting to use Power BI for Google Analytics and website ranking reports.    One of the crucial parts that I'm struggling with is the Rankings line graph. Basically, in order to mak...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

I found a solution to this problem.

To make the graph look positive , we can make a measure for the values and then multiply it with -1.

Then download a "multiple axis chart - XViz" and drag your measure into the values section. This will display an inverted chart but will show the data as negative values.

To change this go to number format and turn on semantic formatting.

Change the negative value format and positive value format to (X). You can change their colours as well. This will now show the values without the negative sign.

 

Regards Aman

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you. the -1 multiplication was normal but changing the representation was clever. Thanks. Its not a solution but its good enough while we wait ( somewhat impatiently ) for a product fix. Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your solution Anonymous, 

     

    Now it's even easier using Multiple Axis Chart- xViz, as they added a new function to 'Reverse Axis', please see the screenshot below for navigation: 

     

    Edit: Darn, the visual is paid