Forum Discussion

Chaimaazyani's avatar
Chaimaazyani
New Member
1 year ago
Solved

Data cleaning remove 0 from decimal values X.0

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!

 

 

Need Help

7 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    1 year ago

    Chaimaazyani , Try a format Like

    ###.##% and check

     

    or dynamic format in measure/column tools

     

     

    "##.##%;-##.##%;##.##%"
  • shafiz_p's avatar
    shafiz_p
    Icon for Super User rankSuper User
    1 year ago

    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

  • Kedar_Pande's avatar
    Kedar_Pande
    Icon for Super User rankSuper User
    1 year ago

    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