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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
PrimaSatria
Regular Visitor

Formatting number with two decimal in Power BI Desktop

Dear All,

Good morning, I need your help and guidance.Visual with $Visual with $
How to format number with two decimal in Power BI?
My visual now appears with $ sign. 

The second, I have a table in text format, containing Jan, Feb, Mar, etc. Added a new column to convert that text into number, and now become 1, 2, 3, etc. How to visualize the month into Jan, Feb, Mar with sorting A-Z?

Thank you very much for your helping hand.

Best regards,
prima indonesia

2 ACCEPTED SOLUTIONS
Ritaf1983
Super User
Super User

Hi @PrimaSatria 
Format number of digits is from here :

Ritaf1983_0-1724120759830.png

If you don't want it as a currency, modify it from :

Ritaf1983_1-1724120861586.png

According to the sorting months chronologically, you can modify it be the months's numbers that you added from the table view :

Ritaf1983_0-1724121053788.png

Result :

Ritaf1983_1-1724121098091.png

The pbix with the example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Dear Ritaf1983,

Thank so much for the solution given. 
Sorry for late respon, but acctually I already follow your instruction on the day you replied my post.

Thank you so much, really appreciate it !!!

Best regards,
prima Indonesia
 

View solution in original post

7 REPLIES 7
Ritaf1983
Super User
Super User

Hi @PrimaSatria 
Format number of digits is from here :

Ritaf1983_0-1724120759830.png

If you don't want it as a currency, modify it from :

Ritaf1983_1-1724120861586.png

According to the sorting months chronologically, you can modify it be the months's numbers that you added from the table view :

Ritaf1983_0-1724121053788.png

Result :

Ritaf1983_1-1724121098091.png

The pbix with the example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Dear Ritaf1983,

I am sorry, I should not give my response as a solution, since the solution was provide by you. How can I fix this?

Thank you

 

It seems ok, i pressed go-to solution and it brought it took me to my response 🙂

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Happy to help ♥️

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Dear Ritaf1983,

I have another question. I have a measure of total employee using countrows, the problem is when use Card (new) then number from 1,470 turns into 1K. Even though I am formatting in Whole Number with comma, still won't change.

If I am using Card, then it shows 1,470. 

Please find the picture to get a clear massage.

Again, thank you very much.


Best regards,
prima IndonesiaFormat NewCard.png

 

Dear Ritaf1983,

I found the solution. I changed the display unit in callout value into None. And now it shows 1,470 as I want.

Thank you

Best regards,
prima Indonesia

Dear Ritaf1983,

Thank so much for the solution given. 
Sorry for late respon, but acctually I already follow your instruction on the day you replied my post.

Thank you so much, really appreciate it !!!

Best regards,
prima Indonesia
 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors