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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
JBeyers
Helper III
Helper III

Howto change PowerBI prefix

Hi, 

 

Since a week or so PowerBI doesn't show the Metric Prefix anymore. Instead, it shows "Duizenden" since my native language is dutch. In English, this means it shows "Thousands". 

 

I want PowerBI to use the M, K, G, ... prefixes, how can I do this?

 

Thanks!

4 REPLIES 4
Bjoern
Continued Contributor
Continued Contributor

@JBeyers

 

It's an option inside the visual. There you can specify the unit of the Measure/KPI you are showing.

 

[img]http://i.imgur.com/79OWaVE.png[/img]

@Bjoern I know, but I want to use PowerBI to show "K" instead of "Thousands" or "M" instead of "Millions". 

Like it was a few weeks ago.

 

Also I'd like to use the English unit instead of dutch/deutsch units.

 

Do you know how to change it?

I am using English so I haven't tried it but it seems like it can help you. Describing what you asked in DAX.

http://www.itsmart.nl/2015/11/24/power-bi-desktop-tip/

 

You can change the file import region format by File-> Options & Settings-> Options ->Under Current File

 

 

1.png

Konstantinos Ioannou
Bjoern
Continued Contributor
Continued Contributor

@JBeyers

 

First question: I do not know. Perhaps it was changed by default.

 

If you want to use English units, you have to install the English PBI desktop version. For the Web-Service it is determined by your local language settings of the windows-user / MSIE.

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors