Scatter chart two numerical values not plotting

[LSWilliams94]

Hi

I'm trying to see if there's a relationship between tenure and salary in my HR dataset, i'm using a scatter chart but when I add tenure to x-axis and salary to y-axis, click do not summarise to show each individual plot pair, i'm getting a "if your x-axis is categorical, choose a summarisation for the x or y-axis" error. How can I check if my values are categorical? i do not want them to be.

[Anonymous · Accepted solution]

Thanks for the replies from suparnababu8 and rohit1991.

Hi @LSWilliams94 ,

Please recreate a scatter chart and set the x-axis type to continuous instead of categorical:

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[suparnababu8]

Hi @LSWilliams94 

I think your Tenure column having the Categorical data type. Make sure to check the correct data types of columns before adding it to x-axis and Y-axis. The primary rule to add values to X and Y axis of a scatter chart is 1N + 1N
N - Numerical columns

You can check the data type under column tools in PBI desktop. If you need correct solution Pls provide sampl data and expected output mockup. Make sure while sharing the data don't include sensitive information.

Thanks!

[LSWilliams94]

Thanks for the reply.

I can't see how to upload the file so I will post screenshots.

Even when I'm adding any other numerical fields, it's not liking it.

I would just like to a see a plot for every pair: (62506 : 14, 64991 : 17)

[rohit1991]

Hi, @LSWilliams94 , The issue arises because Power BI might treat tenure or salary as categorical. To fix it:

1. Check Data Types: Ensure both tenure and salary are set as Whole Number or Decimal Number (not Text or Categorical).

2. Summarization: Set both fields to "Don't summarize" in the properties and ensure no default aggregation is applied.

3. Rebuild Chart:Remove the current scatter chart, recreate it, and re-add tenure to X-axis and salary to Y-axis.

This ensures both fields are treated as numerical.