Excel table not showing decimals on PowerBI

[louiem1998]

Hi,

I have imported an excel file to PowerBI, it has a table which has decimals but only one column is showing with the decimals when uploaded, the others are not. I can't work out why?

Excel Table - type are all "number"

Table view in PowerBI - only 2023 is showing as decimals?

Query Editor in PowerBI - all are set to "Decimal Number"

The cards in my report not showing a decimal for 2022 and 2021:

Any help would be really appreciated, thanks!

[Ritaf1983 · Accepted solution]

Hi @louiem1998 
It is hard to check the problem without access to the excel.

If the file is xls, change it to xlsx.

If it is already xlsx
Try to change the data type in Excel to text, and set a decimal format in the power query after importing.

If it won't help please share a link to the Excel.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.