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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors