Show numbers in Thousands or Millions in same column with the new Dynamic formatting in Power BI

If you want to be able to conditional format a number in Power BI as k for thousands and M for millions in the same column, the new Dynamic Formatting can do that for you.

Prefer in blog form? Check it here:

Check this video to learn how.
Download the sample file at the download center , number 079.

Join this channel membership to get access to all the recorded bites as they become available:

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen

#CURBAL #SUBSCRIBE

[rauljimenez]

Thank you very much, as always this was very useful!! One thing I found is that we have to set the format of the Values to "None" (instead of "Auto"). I was getting some weird results before I figured that one out.

[ivanmezev]

Before that don't forget to turn on "Dynamic format string for measures" from Preview features

[NearbyCactus]

Funny thing is just last week I created a solution for this using calculation groups (I was unfamiliar with calculation groups, so it was time-consuming), and Monday morning I discover this new feature, which would have been far easier. But at least I now have a better understanding of calculation groups. 😅

[mehblahmehblah]

This should be
A) the default presentation mode
B) in the visualisation panel, not excel formatting code in hidden drop down panels

But - glad to have the option now!

[andyjohnson]

This is much overdue, have been using calculation groups up to now, relieved I no longer have to do this! I already store the dataformat mask in a table and refer to that in order to determine the correct mask, works brill and best of all allows these masks to render against charts. Thanks for the vid!

[oscarmike]

This is a godsend. In my previous experience creating dashboards for plant operation being not able to use multiple formats was painful

[dionisioneto]

Great tip. Here is another code that might help for Milions and Thousands with two units after comma:

indicator =
VAR Valor = SUM(tablecolumn])
RETURN
SWITCH(
TRUE(),
Valor >= "#, ##0.00 M"),
Valor >= 1000, FORMAT(Valor/1000, "#, ##0.00 K"),
FORMAT(Valor, "#, ##0.00")
)

[AhmadBELAL-fssx]

Thank you so so much. This really helped me finally sort this out. You're the best

[youtubeMysteries]

negative didnt capture correctly with this method

[sivarams]

How do I display only values and remove unit M

[FreeWmn]

Woooow esos trucos elegantes me encantan, amo tu canal amiga bella!

[All_abt_beauty]

Thank you so much. This quick tip is really helpful ❤

[HiwaEssa]

Thank you very much! very useful tip and easily explained.

[rahulnalawade]

Format option is not visible near DAX writing area in power bi for me. I am using latest version of power bi.

[osama.hassanin]

Excellent feature, but what about numbers in axis, the format is weird. any suggestions.

[htctihp]

Why wasn't working sum(abs(sales))

[htctihp]

Can we get the display units when use the >= for the value

[wkswcwv]

this is super useful. Thank you so very much!! Your content is always helpful and practical :)

[akashchauthmal]

Thanks for the video. I have tried all steps but its not working in my case. I have connected to live dataset, is it because of that ? Please tell me how to dignose this issue. Would be great to know if any alternative there

[arunantony]

Useful to display in matrix or chart. But table data when exported to excel just appends an M or K to the large value. (As on sept 2023)