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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors