Data Type Error

[wolbertkj]

Hello,

I recently had data on an excel sheet that was text. In Power Bi, changed that text to equal a certain number (so green=1, yellow=3, and red=5). Because I was having so many issues with this and the guage visual which I downloaded, I switched the excel sheet back to being numbers rather than words. When refreshing in Power Bi, I now get and error in those columns. I switch the data type back to whole number, but the error remains.

Can anyone help with this?

Thanks!

[v-chuncz-msft · Accepted solution]

@wolbertkj,

You may check steps in The Advanced Editor.