New to PowerBI and need help with formatting the way numerics show

[Anonymous]

For some reason some numbers show up with multiple decimals places instead of just the ones that were entered. My info is pulling for an excel spread sheet and uses both letters and numbers so i need to be able to show both, i just want to get rid of all the extra decimal places. I'm not sure how or why BI is adding them anyways. I'v inserted a table into my dashboard in order to project the needed information.  

In the screenshot below, the 19043.0099.... was input in my excel sheet as 19043.01 yet powerbi changed it. I just need it to show as 19043.01 

Any help would be much appreciated. 

[v-qiuyu-msft]

Hi @Anonymous, 

You can create a calculated column like below: 

Column = 
var dict=SELECTCOLUMNS(GENERATESERIES(97,122),"Ch",UNICHAR([Value]))
return
IF(COUNTROWS(FILTER(dict,SEARCH([Ch],[Invoice],1,-1)>0))>0,[Invoice],ROUND('Table'[Invoice],2)&"")

Best Regards,
Qiuyun Yu

[Arjun_SP]

@v-qiuyu-msft  Select the field that you would wish to alter the decimal placed from the field list and go to modelling >> and change number of decimal places.