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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.