keep the 2 digit decimal when export a value to excel, but in table visual in Power BI is integer

[oakfootballclub]

Is there a setting could make it like that?

[MFelix · Accepted solution]

Hi @oakfootballclub ,

Not sure what visual you are using but if you use a decimal column on the visual and then change the decimals places to 0 you will get the integer values on the visualization but on the export you get the decimal values:

[Anonymous]

Hi @oakfootballclub ,

Thanks for @Uzi2019  and @MFelix replies.

@oakfootballclub You can also try DAX as follows.

Measure  = FORMAT([Column],"0.00")

Best regards,

Mengmeng Li

[Uzi2019 · Accepted solution]

Hi @oakfootballclub 

You can simple change the whole number to decimal after loading data to power bi.

1) select your column

2) go to column property

3) change data ype to decimal by entering 2 in decimal place.

4) it automaticllay converts to decimal. so next time when you load the excel file it will show 2 decimal number in the table.

I hope I answered your question!

[MFelix · Accepted solution]

Hi @oakfootballclub ,

Not sure what visual you are using but if you use a decimal column on the visual and then change the decimals places to 0 you will get the integer values on the visualization but on the export you get the decimal values: