Forum Discussion
Scatter Plot With Line Connecting Plot Points to X-Axis
With lots of googling and youtubing I was able to figure it out. Got exactly what I needed.
I used a basic bar chart and set the X axis to the max of my measure and the min to 0 and used the measure as the axis itself. On the Y axis I used the categories but of course they only did a count of 1. So I made a calculation group item that used the category name as the output string and placed that on the visual as a filter. Voila. Categories on top of each bar and each bar is plotted along the continuum.
I'm not getting the desired outcome. Looks like the series label is not available for clom chart or scatter plot. If this is important to you please consider raising it at https://ideas.powerbi.com
See attached for both attempts.
With lots of googling and youtubing I was able to figure it out. Got exactly what I needed.
I used a basic bar chart and set the X axis to the max of my measure and the min to 0 and used the measure as the axis itself. On the Y axis I used the categories but of course they only did a count of 1. So I made a calculation group item that used the category name as the output string and placed that on the visual as a filter. Voila. Categories on top of each bar and each bar is plotted along the continuum.
Realize this is old, but I stubbled on it when looking how to recreate something I had done in the past. In case others, or myself in the future, are looking for this I thought I'd add an alternative I've used (and remember now but likely won't later!).
I used a X-Y scatter chart. With the + in the upper right of the chart you can add an error bar. It seems to pick horizontal automatically, but you want vertical. You can change this in the upper area of the menu that will pop out on the right of the screen after you add an error bar. The option to select a vertical (Y error bar) is hidden under a light blue chevron pointed down. Once you have the vertical error bar, choose to exend it down only (minus) and set the option for "Percentage" and set the percentage value to 100. This will extend an error bar down (minus) to the X-axis (100%). In the paint bucket I also set color to match the dot on the graph, the transparency to 75% and the width to 2.5, but you can customize this to how you see fit.
Cheers!
