Forum Discussion

madji's avatar
madji
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

Need Help
  • v-jiascu-msft's avatar
    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

5 Replies

  • Salvador's avatar
    Salvador
    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

     

    • madji's avatar
      madji
      Helper I
      9 years ago

      Salvador

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

       

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    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

  • Nargiz1977's avatar
    Nargiz1977
    Regular Visitor
    7 years ago

    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