Forum Discussion

MaartenH's avatar
MaartenH
Frequent Visitor
10 years ago
Solved

Power BI doesn't use decimals

Hi,   Been trying all afternoon to get a dashboard together. Problem is that when I upload data with amounts like 2.5 & 3.6,  the dasboard adds these up in a graph/table etc. as 2 + 3 = 5 instead ...
Need Help
  • MaartenH's avatar
    MaartenH
    10 years ago

    Never mind, 

    In the edit query I found that in the "applied steps" window i made 2 (historic) alterations for the data, first I made it a "whole numer" then a couple steps later a "decimal"....deleted the first step and the data came through ok. 

     

    Solved, -1 kudo for meself!

     

    thanx for the input though!

jsBrizius's avatar
jsBrizius
Icon for Helper I rankHelper I
10 years ago

 

 

 

 

 

 

Maybe the Data Type of the column needs to be Decimal Number.  I created a new column that adds 2.5 and 3.6 and it shows 6.1.  Maybe check your formatting as well?