Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to create a scatter plot with x and y values, similar to how I would do it in Excel. I can write a query to associate distinct numeric x and y values, but when I plot these values, the scatterplot is drawn so that all plots are evenly spaced along the x axis.
For instance, I have three points, (2, 3), (3, 5), and (5, 8). Each point is correctly drawn along the y axis at y=3, 5, and 8, respectively. However, while I would expect (3, 5) and (5, 😎 to be twice the distance along the x-axis as (2, 3) and (3, 5) are, they are instead evenly spaced. Displaying my data as a line plot produces similar behavior.
Each data point also has its own label along the x axis, rather than periodically labeling values as is done with the y-axis. My guess is that it's because Power BI is treating my x-axis data as categories, which would also explain the spacing behavior.
Any idea why this is happening, and how to get the scatterplot to behave like Excel?
EDIT: A scatterplot in R (drag in the data values from the PowerBI query, use "plot(dataset)") also works correctly. So it's not an issue with my data being malformed.
Solved! Go to Solution.
Hi @Hansinator255 ,
What is your desired result?
You could modify the X distance and Y distance for your visual in the setting:
Regards,
Daniel He
OK, I think I figured it out. While my data is numerical, it was not being statically typed as such, and I had to add a Change Type step to my query to change the X and Y columns to Decimal Number. When I did this, the X and Y axes appeared correctly scaled and I could modify the axis scales for both.
Hi @Hansinator255 ,
What is your desired result?
You could modify the X distance and Y distance for your visual in the setting:
Regards,
Daniel He
@v-danhe-msftThat does look like what I want, and I do get those options for the Y axis on my data. I do not, however, get those options on my X axis and instead get options for displaying categories, even though both my x and y values are numeric.
Note also that an R scatterplot displays this data correctly. I've edited the question post to reflect this.
Hi @Hansinator255 ,
It do could set with the X-axis on my side:
My data(all number):
I suggest you test again or you could download my pbix file to have a view.
Regards,
Daniel He
OK, I think I figured it out. While my data is numerical, it was not being statically typed as such, and I had to add a Change Type step to my query to change the X and Y columns to Decimal Number. When I did this, the X and Y axes appeared correctly scaled and I could modify the axis scales for both.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |