Decimal place not working

[NLEIGH]

Hi,

Iam having troble getting Power BI to show a decimal place correctly, i've imported a simple file and it shows the decimal place correctly for holiday 2.5 (see screenshot below), however when I try to pull this data into a Table it shows as a "3" rather than 2.5.

I'd be grateful if anyone can help.

Many thanks,

[zenisekd]

Hi @NLEIGH , when in Power BI select the column in Data list you are interested in and adjust the displayed decimal places. 

Kudos and mark as solution appreciated.

[zenisekd · Accepted solution]

Change the Type from Whole number to Decimal number. 🙂

Kudos and mark as solution appreciated 🙂

[NLEIGH]

Hi, Thanks but I had already done that, please see below, but still not showing as 2.5 !

[NLEIGH]

Great thanks, thats has worked, really appreciate your help