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.
Would you like to engage in some List.Generate() or GENERATESERIES() trickery? If yes then please provide sample data.
It's fairly straightforward. I have categories, and then values for each category. I've tried bar charts, line charts, matrices, custom visual downloads, you name it. I think if anything, a basic bar chart would be fine. I just need the x-axis to be made up of the values on the table with a bar or line extending up to the category label as in my example. I thought if anything, I could do a Y-Axis of say 1 and 2, so if any two category values are close to one another, they wouldn't overlap.
Unforuntately I am unable to attach a file here. It isn't in my options. But if you can create a basic input data table with one column being the categories, and the second column being the values, that would be the data sample I'm working with.