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.
Please provide sanitized sample data that fully covers your issue. I cannot help you without meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
- lbendlin4 years agoSuper User
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.