Forum Discussion
Scatter Plot With Line Connecting Plot Points to X-Axis
- 4 years ago
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.
Missing the plot point for each category.
- lg15514 years agoResolver II
Sorry for the double post. Not sure why it posted twice. The plot points will just be alternated to assure the category labels on each column don't overlap. Thank you for your time with this.
- lbendlin4 years agoSuper User
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.
- lg15514 years agoResolver II
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.