Digging into DYNAMIC format strings for DAX Measures in Power BI

DYNAMIC format strings recently were made available for DAX Measures in Power BI Desktop! Zoe walks us through how you can use these to enhance your reports!
Create dynamic format strings for measures
learn.microsoft.com/power-bi/...
Zoe Douglas
/ zoedouglas-data
/ datazoepowerbi
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #MicrosoftFabric #GuyInACube

[@jamesmorse5923]

Great video! Never thought I could use dynamic strings like this, but brings many ideas to my visuals.

[@nashahan]

Nice work Zoe! great to see you on the cube tube!

[@datazoepowerbi]

Thank you!!

[@gkirankumarskht]

Awesome Video. Thank you Patrick.

[@JimmyGrewal]

What would be the best way to format a column containing gigabytes of data to be labeled as GB, TB, or PB depending on the value?

[@Ark2theMoon]

I’m using this feature to get around having separate measures for average times in decimal for charts and text for tables but does this carry over to report builder?

[@TamNguyen-cy3ix]

Thanks for this! What should I do if I want to present the number as even more customization such as 100 million? e.g. my sales are 900,000,000 and it should give me 9, instead of 900M or 0.9B

[@ActionableAnalytics]

Does anyone have issue with displaying dynamic format strings on chart axes (e.g. Y-axis)? I noticed that the Y axis was disabled for this demo and I had issues displaying dynamic format strings correctly on chart axes. Any thoughts welcome.

[@jeremybanas4832]

This is awesome!

[@TigerGamesEthan]

wow, been wanting this feature for ages

[@chrisburton4259]

Q can this be used to format lines in a chart if you want set colours for specific items I.e product A is always blue product b is always red? Great video btw

[@ivychen390]

Will the dynamic format carry over when you pull an existing Power BI dataset into a new .pbix file?

[@antique-bs8bb]

I'm trying to use dynamic format strings to get m:ss formatting (yeah I know it is n:ss because m is for months).
Doesn't seem to work.
I can use Format in the measure but that doesn't sort well 15:25 is before 1:55 because the output is a string.
I could use formatting in the Format pane for the visual - but I have to do that every time.
Surely just "n:ss" should work as a (not very dynamic) dynamic format?
Any ideas why it doesn't? it works with numbers.

[@chethan4160]

only problem with this is if the value in nagative id oes not make sense example: value-25 it shows -USD 25 insted of USD-25 is there way to do USD-25

[@duncan2254]

I don't have the dynamic in format field.

[@francisjohn6638]

Pretty Awesome :)

[@noahhadro8213]

It would be great if everyone could vote this idea up to improve the performance of the dynamic DAX formatting. I believe this idea might be able to significantly help this feature in many use cases. The idea title is: "Optimize dynamic format strings for DAX measures"

[@datazoepowerbi]

Thanks for letting me know! I'll take a look

[@rafacasima]

Clearly Brazil is not switched. All the world is switched and we are right 😅

[@datazoepowerbi]

Exactly! :)

[@guppi1]

​@@datazoepowerbiI wonder how the locale table looks like. What format did you use so Brazil can have period as thousands separator and comma as decimal?