Data cleaning remove 0 from decimal values X.0

[Chaimaazyani]

Hi, could you please help me remove 0 in decimal number here? 

ex: ( 68.0 should be 68 and keep 75.4 as it is ) 

Thank you!

[Chaimaazyani · Accepted solution]

Solved using custom format Strings

[Kedar_Pande]

@Chaimaazyani 
Calculated Column:

FormattedNumber = 
IF(
MOD('YourTable'[YourColumn], 1) = 0,
FORMAT('YourTable'[YourColumn], "0"),
FORMAT('YourTable'[YourColumn], "0.0")
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Chaimaazyani]

Doesn't work. Same result

[shafiz_p]

Hi @Chaimaazyani  Select visual and go to data label in format section, go to value and place decimal places to 0. See images below:

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz

[Chaimaazyani]

Doesn't work

[amitchandak]

@Chaimaazyani , Try a format Like

###.##% and check

or dynamic format in measure/column tools

"##.##%;-##.##%;##.##%"

[Chaimaazyani]

Doesn't work