PowerBI – Number and Currency Formatting

After looking for a solution why my Number Formatting did not want to work out…

After creating a new Measure it returned the classing US based formatting.

image

While I wanted to have the EU formatting in my table.

Power BI Desktop Client Regional Setting :

Even after changing the Power BI Desktop Client settings, it did not take effect Sad smile

image

Solutions :

Go to Control Panel –> Region –> FORMAT

image

If this format is not in line with your region it will overrule the Power BI Regional settings ?

image

So after applying the correct region format settings on OS level, everything appeared as expected Smile

PS : These figures are just demo based Winking smile

Enjoy!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: