Use DAX to Show Values in any Way You Like! Dynamic Format Strings in Power BI

In this video I show you how to control number formats with DAX! A better way to Display Values with Dynamic Formats in Power BI.

Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
01:03 One measure - multiple currency formats
09:42 Switch between different units
13:15 Measure-driven labels
19:38 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[giorgiopresicce]

I found it incredibly useful, as always! Thanks for consistently updating all of us with the latest and most innovative content! I truly appreciate it!

[MIRCOR]

Amazing video! Your workaround for measure driven labels solved my problem!

[alicedwonderland]

Bas, fantastic video as always! Note to my fellow watchers: remember to first go to the report Options and enable this preview feature.

As for a use case, how about when you have a beautiful switch between Amounts and Quantity? This is what I'm using it for. Amounts must be in thousands, and Quantity in, well, regular formatting. And for thousands, I used "#, ##0, .k", to see the 'k' at the end.

Update: fudge, the formatting is a mess when we use it in a visual (the thousands one) and apply data labels! It's all over the place!

[vishalnasre]

This is really out of the Box
Thanks Bas for great video.

[ruioliveira]

Thank you very much for these video. Was exactly what I was searching for. You are great!!

[PeterFabian-gulp]

Thank you mate, I've struggled with formatting for half a day, you saved my @$$ and won a new follower! ;)

[walteradamsbe]

Hi Bas, great tutorial (like always).
I have a use case to have different formatting for every row from where I work: we have a sales table visual which shows a number of rows of sales actuals (in EUR) with right below it (in the same table) the number of units sold (of course in absolute values).
It's not my preferred visual to do this because I find it confusing but management is used to this table so there you go 🙂

[patitosamsungtelita]

Hola Bas,
Eres un crack.
Mil gracias por compartir tu sabiduría.
Abrazo fuerte

[alicedwonderland]

Thank you, Bas! You make my work shine!

[anneetaylor]

Thanks, especially for sharing the dimCurrency Table :)

[edwinarchico]

As always, excellent Bas, thank you!

[davemurdoch]

Hi Bas, great channel. Great videos. As a suggestion : I would love to see your version of reconciliation. In quantity and financial value maybe even with currencies. Accounts Receivables also very interesting. Thanks for the inspiration.

[digitsletters]

Thank you! Regarding dynamic formatting - will try it in matrices, I often use dynamic columns with some additional calculations following a set of periods (e.g. % variance of last period vs the previous)

[unnikrishnansanthosh]

if its BAS then something out of the box, great thanks for sharing

[datactive]

when I was noticed with april update earlier this month, I knew Bas is going to give this lecture. Thanks bro, your version is the best

[JurgensvanEeden]

Awesome video excited to try it out. Do you know if this will work for a visual that uses a field parameters those different values. At the moment i end up when some of the measures returns small amounts it wout show 0, 0k.

[markhenderson]

Thanks for the content. Is there a way to add color to dynamic formatting? For example, I am in a table column and I want to use a UNICHAR arrow and make the up arrow (9650) green and the down arrow (9660) red, all within the dynamic formatting.

[marc-andreperreault]

Hi Bas,

Great content as usual!
I have a use case, where I present a line chart and I'm switching between different measure (sales, units, baskets, etc.).
The dynamic option for my calculations works fine, but the Y axis labels is not always following. Is there a way to make sure the Y axis also displayed the good units ?

Thank you!

[LeighRadmore]

Thanks for this - we had a user requirement to show a measure value in K or M based on the the length or value itself and I just made a way to do this automatically with dynamic formatting - wouldn't have known about it if not for this video.

[Cleanfreak]

Hi Bas, super helpful and very well explained video. May you please add a video, with option allowing only currency symbol to be in bold and the figures as normal. Thank you