Forum Discussion

LSWilliams94's avatar
LSWilliams94
New Member
1 year ago
Solved

Scatter chart two numerical values not plotting

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 t...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

LSWilliams94's avatar
LSWilliams94
New Member
1 year ago

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's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

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.