Changing number format globally on all reports to use M for thousands and MM for millions

[Kerry_M]

My Company wants to change the number format on all reports to show MM for millions and M for thousands (instead of M and K). I have dozens of reports with hundreds of measures. Is there any way I can change the default setting in Power Bi to use M abbreviations for thousands and MM abbreviation for millions? Perhaps by changing the language or regional settings or something?

Any suggestions?

Thhanks

[parry2k · Accepted solution]

@Kerry_M Yes you can surely use, one by one, or you can create a calculation group, and in that, you can set the format string, it will be applicable to all the measures.  Video on dynamic format: From Thousands to Billions: The Power of Dynamic Formatting in Power BI - April 2023 Power BI Update...

Playlist on calculation groups:  Calculation Groups - Power BI - YouTube

[Kerry_M]

Thanks so much for this. I will check out those resources

[Kerry_M]

Here is an update on my issue. It is not a solution as it will only work for one measure at a time, but if you are trying to format a measure using the M or MM notation then you can use DYNAMIC formatting with the following steps (with many many thanks to this CURBAL VIDEO (https://www.youtube.com/watch?v=ROyVkQ9vTjc&t=96sO for showing me how to do this:

1) Make sure you are using Power BI Desktop April 2023 or later release

2) Make sure the preview feature is turned on for Dynamic format string fror measures
(choose File > Options & Setting > Options > Preview Features and a checkmark for Dynamic format string for measures). You will need to restart Power BI to enable the change.

THEN

1) Click the measure (so that you can see the Measure tools ribbon)

2) in the Measure tools  ribbon, choose Format > Dynamic

3) Click the drop arrow beside the measure dialog box on the measure bar and select FORMAT

4) Enter the following code:

VAR MyMeasure = [your measure name goes here]
return
Switch(True(),
MyMeasure<=-1000000000, "#,,,.00 B",
MyMeasure<=-1000000, "#,,.00 MM",
MyMeasure<=-1000, "#,.00 M",
MyMeasure<1000, "0",
MyMeasure<1000000, "#,.00 M",
MyMeasure<1000000000, "#,,.00 MM",
MyMeasure>=1000000000, "#,,,.00 B")

[parry2k]

@Kerry_M nothing default afaik.