Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 climbs up.
First I tried was to create the simplest ever "new column": -[DEPTH]
It works, and the graph now goes down. However the legend is also negative, which I dont like.
Spotfire has an option to graph inversely. But I cant find nothing like that in Power BI.
¿Can any one help, or figure out any way to show the legend without the 'minus'?
Thanks in advance!!
Sergio
Solved! Go to Solution.
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:
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/)
Hi SergioJG,
Could you share some sample data and clarify more details about your requirement?
Regards,
Jimmy Tao
Imagin a set of data as follows:
On a standard line graph, that will be line starting on 0,0 going to the right and climbing up:
However, I am trying to plot depth, and a positive depth value should be below cero.
First idea was a 'new meassure' turning DEPTH column into a negative value, so the excel input can still be positive:
DEPTH 2 = -[DEPTH]
But still the legend is negative.
How can I plot my positive value in this second way, or hide the "minus" on the Y axis if I just change the sign with a calculated column?
Thanks!!
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:
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/)
Thanks MarkLaf,
I will try that in the upcoming days and let you know. On your example looks working exactly as I need!
Thank you very much for your time and support.
Sergio.
Solved!
Thank you very much. Working nicely!!
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |