Forum Discussion
Create scatter chart with actual numbers
I am having an issue with the scatter chart. The example of what I am trying to do is here: https://courses.engr.illinois.edu/cs199205/sp2016/discovery/gpa_of_every_course_at_illinois/
I guess the example's chart has been created with Python. My chart does not have to be similar.
My issue is class numbers. I have class numbers like 310, 320, 330, 410, 460, 600, 680, etc. When I put class numbers to "X axis", it has options "sum, average, min, max, etc.".
I would like to see class numbers without any calculation. For example, if I have 50 students in class number 310, scatter chart should have that number.
Hope I explained it clear.
Thank you in advance!
6 Replies
- Nhallquist
Helper V
If I understand the issue correctly, you would like the class numbers to be like text labels, and not be summarized by Power BI. If this is the case, try changing the format of the numbers to Text. If that doesn't seem to work, try changing the format of the field in the query editor or somewhere closer to the source. If that still isn't working, try adding an Alpha character to the field, or maybe make if more descriptive with a Department name.
Nate
Thank you for your reply but that does not work. X axis and Y axis always needs a calculation (sum, average, etc) even it is text. When I convert the value from whole number to text, it still appears as "count of class numbers".
v-qiuyu-msftCommunity Support
Hi burak,
In Power BI Desktop, a scatter chart always has two value axes to show one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. So it's expected that the X-axis displays aggregated values for numeric fields or nonnumeric fields. For more information, please refer to this article: Tutorial: Scatter charts and Bubble charts in Power BI.
In your scenario, as you want to display values in X-axis without aggregation, I would suggest you create a column chart or line chart instead of a scatter chart. Because their Axis value will not be aggregated whether it's numeric values or not. See:
If you have any question, please feel free to ask.
Best Regards,
Qiuyun YuApparently, there is no this kind of feature yet. Hope it will be possible soon.
Thanks.
norahfoxAdvocate III
You could try the custom visual SandDance. I'm not sure if it'll work exactly as you want - it has an annoying tendency to convert fields marked as text to numbers, but hopefully you can figure out a way around that - but it does allow you to put text fields in the axes and has a lot of options for customizing how it appears.
- Vicky_Song
Impactful Individual
burak, the scatter chart is always used to show scientific data in X-Axis and Y-Axis, so you always get the aggregate functions. If you would like to check the very detailed information without any calculation, instead of using scatter chart, you may consider using the Table or Matrix chart.
