Forum Discussion
How do I make this visual ?
Hi topazz11
Start by unpivoting all columns except Group. Then, use a stacked bar and line combo chart. Create two measures for the column series: the lower bar should be set to transparent, and the upper bar should represent the ± range stacked on top of it. For the line series, set the line width to zero so it’s hidden, but keep the markers enabled and visible. Finally, adjust the min and max values of the y-axis for both the line and the columns so they share the same scale using conditional formatting.
The second image below uses the combo chart. Would have been with a line chart with error bars but there is a limit as to how wide the error bars can be.
Please see the attached pbix.
here is a workaround for you, however, the data display is not correct because so far we can only display what you want and can't display the data as well.
pls see the attachment below
Thank you for the help.
So, is it not possible to include the value (represented by a blue dot) in the visual as well?
This is quite close. A column and line chart, with the lines removed but markers kept visible, would achieve the desired result. However, both the columns and markers need to share the same minimum and maximum values on the x-axis to ensure proper alignment.
