Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
harib
Post Patron
Post Patron

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.

 

8.png

 

Thanks in advance

 

1 ACCEPTED SOLUTION
VasTg
Memorable Member
Memorable Member

@harib 

 

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

Connect on LinkedIn

View solution in original post

8 REPLIES 8
VasTg
Memorable Member
Memorable Member

@harib 

 

Use Custom format in model tab.

 

image.pngimage.png

 

If it helps, mark it as solution

Kudos are nice too

Connect on LinkedIn

@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
Memorable Member

@harib 

 

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

Connect on LinkedIn

Could you please explain the logic?

@VasTg 

 

Yes. It's working perfectly. Thanks a lot @VasTg . 😊

Tad17
Solution Sage
Solution Sage

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/...

 

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)

@Tad17 

 

I have tried but replace with blank not acccepting. 

 

9.png

Hey @harib 

 

Try converting the column to text in the modelling tab to see if the replace will work.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.