Format data

[madji]

Hi,Everyone

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

[Nargiz1977]

Hi everyone, maybe someone can help me I would like to change 0 to dash format. Is it posible in Power BI? And one more I would like present data in thousand but do not show K in report data

[v-jiascu-msft · Accepted solution]

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

[madji]

@v-jiascu-msftThanks so much

[Salvador]

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 , 😄

[madji]

@Salvador

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