Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Dear All,
Good morning, I need your help and guidance.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
Solved! Go to Solution.
Hi @PrimaSatria
Format number of digits is from here :
If you don't want it as a currency, modify it from :
According to the sorting months chronologically, you can modify it be the months's numbers that you added from the table view :
Result :
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
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
Hi @PrimaSatria
Format number of digits is from here :
If you don't want it as a currency, modify it from :
According to the sorting months chronologically, you can modify it be the months's numbers that you added from the table view :
Result :
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
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 🙂
Happy to help ♥️
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 Indonesia
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