Unable to Add Data to Y Axis on Scatter Plot Visual

[cpatte7372]

Hello Community,

For some unexplained reason I'm unable to add data on the Y Axis. In the screenshot you can see I'm trying to add 'Total 2 Year Sum' to the Y Axis, but Power BI won't allow that to happen.

Can someone take a look at the PBIX and let me know why I'm unable to add the data.

https://drive.google.com/file/d/1f4uQNWTjeTuMaU_neyzs1Vr2DiyLPTDL/view?usp=sharing

[lbendlin · Accepted solution]

That field is a text field.

Change it to a numeric/currency field.

See attached.