Forum Discussion
Solved
Graph positive numbers as negative
Dear colleagues, I have the next challenge; I am ploting depths. Depth (not height) is a positive value. The largest, the deeper. I can plot that vs. time on a very simple line chart. But the line ...
I don't think you can do this with the default visuals. Besides finding a custom visual in the store, here is how to do it with R scripting:
- First, follow this article if you don't have R scripting set up for PBI yet: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals
- Once set up, you should have R scripting as a visual option, click it and drag in your TIME and DEPTH columns (make sure it's TIME then DEPTH as that affects structure of what you plot with R), like so:
- Then, in R script editor, enter:
plot(dataset , ylim = rev(range(dataset["DEPTH"])) ,lwd=4 , type="l" , bty="n" , col=rgb(0.2,0.4,0.6,0.8) ,xaxt = "n") axis(1,at = unlist(dataset["TIME"]))
(credit to here for getting me started as I'm an R novice: https://www.r-graph-gallery.com/77-turn-y-axis-upside-down/) - Hit Run script button and you're all set:
Legend and values are different properties of a visual so generally you can use the positive number column for Legend and the negative for Values. But this is just the answer without knowing your case. Probably if you can share some sample of your case? Like a screenshot of the visual?