One drawback is that the Blank space column values can't be transparent (at the moment anyway) so they have to be white (or a background colour), which means gridlines don't display nicely.
UP AND DOWN ARROWS CHART SERIES
Add data labels (if required) just for the Average Ratio series.Adjust Data colors so that Difference from 1 Absolute (Pos) and Difference from 1 Absolute (Neg) are appropriate colours, and Blank space is white (or other background colour).
(this is just to allow data labels showing the ratio itself) Put Blank Space, Difference from 1 Absolute (Pos), and Difference from 1 Absolute (Neg) in Column Values.(or you could just use a Stacked Column Chart if you don't need data labels) Assuming your table contains a column Ratio A : B already, create a series of measures:ĪVERAGE ( Data ) //Arbitrary aggregation if each row is a data point.It is a similar approach to the "old-fashioned" way of creating waterfall or Gantt charts in Excel and produces a visual like this: Hi is a suggestion that I hope is close to what you want. My question is has anyone tried this before in Power BI? Any pointers at all would be so very appreciated. I have begun delving into using ggplot and custom R visuals and lots to pick up. I am quite happy to do normal variance plots, but certain people HAVE to see the graph as in my screen shot ( labelled 3) I know enough in Power BI to be dangerous but I can't seem to replicate this visualisation. The key point is that the values "hang off" y=1. This type of chart is relatively easy to plot in Excel by plotting two lines - one series is the ratio of A:B and the other is parity (1), and then selecting Up/Down bars in the Design Menu, and then setting the two lines to "no line". If the ratio is 1, then A = B, if it is less than 1 ( say 0.8) then there could be say an overestimation of B the demoninator and if it is greater than 1, then A could be overestimated. Essentially it is used to track ratios of two metrics ( A and B or A/B) to each other. I've been trying to replicate a "Up/Down" bar chart in Power BI showing the difference of a ratio from parity or 1.
I've been struggling with this for a while and I am posting my first question to this forum hoping for brains trust assistance.
0 kommentar(er)
