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.

suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
1 year ago

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'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.