How to use DYNAMIC FORMAT STRINGS to customise units, changing currencies and MORE // Power BI Guide

In this video were going to look at some of the scenarios where you can use the new dynamic format strings in Power BI.

Link to the full blog post:

🕓 TIMESTAMPS
0:00 - Intro
0:37 - Preface
00:56 - Display Units, The Issue
03:11 - Enable Dynamic Format Strings
08:59 - Dynamic Currencies
13:32 - Preserving Original Data Type

-

📣 Get Demo Files HERE

🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.

📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more

🛒 Power BI TEMPLATES and more at our digital shop

❤ Other ways to SUPPORT us

📧 GET IN TOUCH

🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.

🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!

#PowerBI #DataAnalytics #BusinessIntelligence

[mauriciomillan]

Hi! Nice video! I tried to replicate the first option on my report on a card but it only shows either MM or BB, not the value with the correct format.

[hi_vishy]

Whats the use of measure option besides the format option in dynamic format?

[violazhang-kf]

Hi Fernan thanks for sharing. if we want to show in whole number like 12K, instead of 12.4K, how can we set up the format?

[paul_malewsky]

Is it possible to mix another types of data using this feature? I mean text and numbers.

[eleftheriakoniari]

Using measures with Dynamic format to Ks works fine (12, 000 appears as 12K) but in a bar chart the number appears as 12, 000K. Any ideas why this is happening?

[satishk]

I want to show M for Thousand and MM for Millions .. can you help me to achieve this ?