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

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