Forum Discussion

Icon for Post Patron rank

Post Patron

6 years ago

Solved

How to remove zeros from after decimal point

Hi,

I would like to remove zeros from after decimal point like below output. is it possible to remove and get the out put eactly like below image.

Thanks in advance

VasTg
6 years ago
harib

Change the format to #,###,##0.##

8 Replies

VasTg
Memorable Member
6 years ago
harib

Use Custom format in model tab.

If it helps, mark it as solution

Kudos are nice too
- harib
  Post Patron
  6 years ago
  VasTg
  
  0 is missing . Let's say if it is 0.25 when we format it's giving .25 only. 0.25 has to come
  - VasTg
    Memorable Member
    6 years ago
    harib
    
    Change the format to #,###,##0.##
Anonymous
Not applicable
6 years ago
Hey harib

Greg_Deckler sovled this problem in this thread: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Removing-zeros-from-after-decimal-point/td-p/842591

If this helps please kudo.
If this solves your problem please accept it as a solution.
(And don't forget to kudo Greg's solution in the linked thread)
- harib
  Post Patron
  6 years ago
  Anonymous
  
  I have tried but replace with blank not acccepting.
  - Anonymous
    Not applicable
    6 years ago
    Hey harib
    
    Try converting the column to text in the modelling tab to see if the replace will work.

Related content