[Aya Murr]

Hey! I am trying to chart a scatter plot on PowerBI but it’s giving me this error: “Your x- and y-axis values aren’t playing together nicely. Replace the x-axis field with a numerical value, or change the y-axis field values to summarizations”. The x-values are already in numerical format and the only option for summarizing the y-value is count, which does not display the values. 

The data was imported from Excel and I was able to create the chart in Excel. 

Has anyone encountered that before? Please let me know how to fix it,

Thanks!

——————————
Aya
——————————

[Audrey Abbey]

Aya. 

You say the X-axis values are in numerical “format”. 
Does the column (in query editor) show a numeric data TYPE?

Sometimes, a column holding what looks like numbers to you, actually has a data type of ABC (text) or ABC/123 (General). 
So it looks correct, but Power BI is still treating it as a string. 
Make sure the column data type is explicitly either decimal or whole number. 

Excel takes some liberties with data types that Power BI is not allowed to. 
That may be why you can do it in Excel and not in Power BI. 

Best,

——————————
Audrey Abbey
SR. BI Developer/Analyst
New Seasons Market
Portland OR
——————————
——————————————-