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:
learn.microsoft.com/en-us/pow...
🕓 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
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
/ solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: fernan@solutionsabroad.co.uk
LinkedIn: / solutionsabroad
Facebook: / solutionsabroad
Instagram: / solutions_abroad
🤝 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
Пікірлер: 15
Great explanation, thank you.
Amazing video, very helpful !!!!!
Whats the use of measure option besides the format option in dynamic format?
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 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?
@joserobertodantas1516
6 ай бұрын
"0,.K" "0" for the integer, the "comma" (,) for the thousand and the "dot" (.) whithout another zero after it so it won't show the decimal.
amazing video! thanks man
Is it possible to mix another types of data using this feature? I mean text and numbers.
this is what i am looking for
Феноменально! You are great brainMAN!
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?
@katarinalukic5075
11 ай бұрын
Hi @eleftheriakoniari3392 how did you change the formula for K? I also want to se K without decimals, but it doesn't work for me. I change part of his formula for K, like: Measure
@jorgemendoza1160
6 ай бұрын
I don't know if I am on time, but I think I found it: Go to your graph choosen, data label, and in values pick "None". It worked for me
@eleftheriakoniari3392
6 ай бұрын
I think I had tried it with no luck! Once I get back to the office from my vacation I will check it again! Thanks anyway! Merry Christmas and a happy new year!
I want to show M for Thousand and MM for Millions .. can you help me to achieve this ?