Show only with decimal places in Table

[Easley08]

Hi,

is there a way to remove the .00 from the other Location

needed output should be 

477

294

24

1.29

0

0

Thanks

[v-yanimei-msft · Accepted solution]

Hi @Easley08 , 

Thank you for giving the specific requirements. Based on your description, I think you can achieve the desired effect by following steps.

Please follow these steps:

1.The test table Table is in the following picture.

2.In Model view, select the column you want to modify the data format. Then, change the data format. The specific operations are in the following picture. To learn more about using custom format strings in Power BI Desktop, click Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn.

3.The outcome is in the following picture.

Best Regards,
Caroline Mei
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.