Solved: How do I change the currency format of my sales co...

Anonymous · ‎01-05-2021

Hello everyone,

Currently i'm working on a sales dataset. The problem im facing is that the values within the sales column are not formatted in the way I want to. Whenever I try to change the datatype of the sales column to fixed decimal numbers, it will result in all values being shown as an error. The format with currently shows within the column is the following: (xxx.xxx.xx). I want this currency format to change to USA standards: (xxx,xxx.xx)

I'm dutch and therefore my Powerbi Regional settings are dutch by default, however, I changed this to; English (United States) in the hope of tackling this problem. I've tried various tricks but can't seem to solve it. Does anyone perhaps know how to fix this problem? I'm sorry if the question is somewhat unclear, I am kind of new to PowerBI.

Thanks in advance!

parry2k · ‎01-05-2021

@Anonymous you can provide the custom format in the modelling tab, check it here

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

Anonymous · ‎01-07-2021

Hi @Anonymous ,

Based on your description, you could check if there is the currency format you want in the "$" option as shown below.

Hope that's what you were looking for.

Best Regards,

Yuna

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