Forum Discussion

Helper I

9 years ago

Solved

Format data

Hi,Everyone I am new in Power BI. I have one problem with format data, but I don't know how it change

v-jiascu-msft
9 years ago
Hi madji,

We can see from your snapshot that the data type of "discount" is "whole number" while 0.5 is a decimal number. If we change the data type of "discount" into "Decimal number", the error will be gone.

Best Regards!
Dale

Responsive Resident

9 years ago

Hello,

It seems to be an issue with regional settings, either you have your data source with english format, and power bi with... russian? or the other way.

To solve that, you can either change the regional settings in both places, or.... replace values on the query editor, . for , :D

Helper I

9 years ago

Thanks for your suggestion I tried to do this, but I can't Because it says me "enter value Number"