"Your X and y-axis values aren't playing together nicely" error with simple numeric and datetime

[rightmirem]

I'm new to PowerBI. I'm more familiar with Plotly and Spotfire.

I'm trying to create what (to me) seems to be an incredibly basic scatter plot with datetime on the x-axis and a decimal on the y-axis. To troubleshoot this error I've filtered the data down to a simple, 11 row, 4 column table - but the error persists.

The following is the actual data I'm attempting to chart (compound name and the datttime-copy aren't being used but can be re-generated manually) ...

```
injection_acquireddate,tailingfactor
2019-03-22 16:45:21,1.0018661915117595
2019-03-22 17:02:40,1.0091641386049404
2019-03-22 17:19:55,1.015032972331727
2019-03-22 17:37:18,1.0115925262538266
2019-03-22 17:54:33,1.0070131174288117
2019-03-22 18:11:53,1.001438858221776
2019-03-22 18:29:09,0.9768981217761633
2019-03-22 19:53:22,1.0150662205451095
2019-03-22 20:10:42,1.0084349518517708
2019-03-22 20:27:58,1.016205896945317
2019-03-22 21:02:36,1.0054275815845197
```

I try to make a Scatter chart in PowerBI and I get the error. Very simply, I want a scatter plot with all 11 of the datetimes on the X and all 11 of the actual complete decimal values on the Y.

The tailingfactor is not aggregated.

If I aggregate the tailingfactor data as "sum" - it more or less functions as a work around (the sum on one value is the value) except summing it ruins the decimal (I.e. `1.0018661915117595` becomes `1.0100000000000000`)

This seems like it would be the most basic type of charting possible. Can anyone explain why the error is happening and how to fix it?

---
Chart...

---

x-axis

---
y-axis

[rightmirem]

I accepted @MFelix as a solution because he figured out the decimal thing. 

I also figure out the scatter plot. It's kind of a dumb bug, and a dumber workaround. 

If you create the chart as a LINE chart first, put in all the data and legend, and then CONVERT it to a scatter...it works. If you just create ti as a scatter first, it doesn't work. 

You also still have to average the data points. It seems, if you use a legend, that it is still taking the "average" of only one datapoint (I.e. value / 1) but if you select "dont summarize" (when it appears) it again does't work. 

I also, just FYI, filtered all the null data out using BOTH "is not blank" AND "is not empty." I don't know if that had anything to do with it or not. 

[MFelix · Accepted solution]

Hi @rightmirem ,

Believe this is because of the number of decimals you have on the formatting by default PBI sets the decimals to 2 so if you change the number of decimals to 15 you will get the numbers you need

After you write the number of decimals on the format it will appear has it's showed on the image but you can then change the number of decimals in the format string.