From Boring to BRILLIANT: How CUSTOM LABELS in Power BI Will Make Your REPORTS Shine
Vložit
- čas přidán 12. 07. 2024
- Data labels are not boring... at least not anymore! In this video I show you how to use the new custom, measure driven data labels and how to format them to make your reports shine.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
01:03 Adding Data Labels
01:54 Customizing Data Labels with DAX Measure
05:05 Formatting Data Labels
06:30 Splitting Data Labels over Multiple Lines
12:12 Creating a Toggle for What Shows on Data Labels
18:17 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* 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 - Věda a technologie
I just want to say that not only your videos are very high quality and professional, but you also have a great personality that makes it very joyful to learn and watch. A very talented Instructor indeed. I always choose you among the dozen others out there, so hoping you cover all the topics we need ! You deserve 1M+ subscribers.
What a great video Bass!
The level of detail is great, as you always show and make known. It's amazing everything you learn in each of the sessions you share with us. Always grateful. Greetings
You are the best. Really love your approach, showing all the gotchas, so that when we encounter them, we will know why and also how to work around them. Keep up the good work, man.
Bro, over 10 years I’ve been using CZcams it’s the first time I’ve turned on notifications on my iPad (up until now). With every single of your videos, I need to go back to my dashboards and modify them. Thanks for making me look good at work. 😎
Great video, love how you build it up step by step to get a super awesome result and explaining it in great detail all along the way.
You don't have idea how much help your videos provide! Thank you so much!
Thank you! not only for your knowledge but for passion and inspiration you bring in every video
excellent, your videos are in my top 3 besides SQLBI and Guyinacube 👏👏
Hey bro! You're amazing at using Power BI. I've been using some of your videos in my day-to-day work, and they've been so helpful. You've helped me improve myself and land a better job. Thanks a bunch, man!
Writing from Mexico🤗
This thing I was searching for the last 2 months, thankfully you created a video on this.😃
:):) awesome!
Absolutely amazing. Cannot thank you enough for all your videos. PBI May 2023 updates came with some nifty features and fixes I was looking for my own reports and this video covered exactly that. Well done Bas!!!!
Really happy to hear this thx!
Your attention to detail is amazing. Nice work Bas ! ⭐⭐⭐⭐⭐
Thanks for watching!
As always, a super Power BI instruction 🤩 thank you 🙏
Your passion for PBI is truly inspiring!
I m a big fan of yours as you always give ideas out of the box. Your tips always add additional values to the existing dashboard always.
So nice to hear this, thanks!
Fantastic video Bas, really good stuff as usual.
Thank you!!
straight away to my next dashboard, thank you for sharing BAS
Very useful. Thank you!
Great Bass, thank you for the detail.
Great video as usual. Thanks Bas!
Really helpful for my projects and good informative one !
awesome!
Really cool, needed that exact functionality today
Ah cool good timing then
Thank you so much for this tutorial and more thanks to your gentile and cleaver approch in a very nice step bey sten, I'm really grateful!!!
Thx for watching 🙏 😊
Amazing Bas, thanks a lot!
Sure!!
Hi Bas
Thank you for all your great videos. This new feature is amazing. Do you know how the labels can be show on the y axis scale?
Fx I have first created a lookup measure then the label measure and it works perfectly with your video guide. But how do I show/replace the y scale with the label measure?
Thanks a lot for your dedication! Your videos have helped me more than chatgpt.
Awesome explanation and enrgy
Thanks! What is the difference (or benefit) in this approach VS. the Dynamic format string for measure?
ohoh! Nice video Bas.. Keep going!🤟🤟
Thx a lot! 😄
Hello Bass! Nice video, thank you for the information sharing. Can you ask me a question? I always need to have a created measure to reference the values? Or there's a way that i can pass the value of sum column that is brought directly into the visual?
Hi, thank you very much for shareing this! I wasn't able to find this for the Map visualization, do you know any work around this?
Hi Bas, this is very useful ❤, great video.
Thanks Edwin!
Thanks for the Brilliant Video Bas, MDDL is definitely a game-changer!
One quick question I have on watching your video is this: I noticed the negative YOY% values still have a positive bar chart. Is there a way to format this so that it appears as a negative value below the x - axis = 0? As it is, the measures take the initial dimension of sales - actual and isnt dynamic except for the labels. Or i'm I missing something here.
Your video was very useful! I just found with my dataset it worked great for one column of data vs any additional cluster (e.g. monthly comparison, where column legend previously used), if any tips there?
Great vid Bas
Thats a brilliant tutorial- you are fabulous!
Can I request you to make a tutorial on survey data- expecially analysing survey comments (text analytics preferably with Python visual) please? :)
Bedankt Bas! :)
Good one, thanks for the videos,
Dynamic number format could have been added
Excellent Video Bas
Thanks!
Hi Bas. is there a way to just bold the % value in custom label ?
great video thanks
Good video, in version 2024, do you know where the checkbox is located to enable custom labels?
The video I've been waiting for! Thanks Bas!
Just out of curiousity. Since this is your last video, I will ask my question here :)
Are you working on learning Microsoft Fabric and if so, will you be creating video's about it in the future?
Thx! Yes, I think there will also be some content around Fabric in here
My 2nd question will be what do you REALLY think about it?
Hi Bas, First of all, thank you so much for the amazing content. I really enjoy watching your videos and applying some of the techniques at work. Is this supposed to replace the dynamic formatting strings from the previous versions? At first glance, it seems that we can achieve it without creating a new format measure, but instead, we can directly write what we want under the format DAX expression when we choose 'dynamic' in the format field.
Is your new video intended to replace your previous video titled 'Use DAX to Show Values in Any Way You Like! Dynamic Format Strings in Power BI.'
Additionally, it would be helpful if you could make a short video on how to dynamically play with colors.
Thank you!
Thanks for sharing. Which version of PBI did you use?
Hi Bas , thank you so much for your amazing videos ..
Can u please give an idea about shows values in bar chart like Cr or lakhs in values …
Thank you
This is awesome,Thanks
I'm wondering if it's possible to concatenate the measure titles to the measure values and use this result in the custom label?
e.g. Actual: 123.6
SalesYOY%: 48%
Very nice! I have the english Power BI, but I use the Dutch notations (point for thousand and comma for decimals). I can't get that to work with the FORMAT function. Any tips on how to fix that?
Excelent..!!!
you are amazing!
Great job Bas! By the way, does it work in table or matrix visual?
Hi Bas! Can you please also explain/do a video about how you set the "Show Panes(shortcut icons to Filters, Bookmarks, Selection, Performance Analyzer, Sync Slicers) to the right side of the PBI desktop view? I am referring to this screenshot at 1:11 where the mouse cursor is on. This would help me so much! Thanks in advance
@ 9:35 what’s the keyboard shortcut to delete the other none highlighted line??? Good stuff as always!
This channel is the definition of Klasse statt Masse
Thanks! although some more videos wouldn’t be bad 🙈
Excelent video. Very detailed with great storytelling.
Question: Is it possible paint the left label with one color and the right one with anothe color?
Something like this:
Black label | Red label %
This trick is great for line / column charts. I am trying to use it to a Gauge visual, but it does not work. The Gauge visual only allows one field in the value field, and so there is only one custom label allowed. Is there anyway to do this for the Gauge callout value label? Thanks.
Great 👍👍👍🎉
I love your content
Thanks 😊
impressive
it's nice!
Hi Bas, have you managed to work the field paramters (measures inside) to work with conditional formatting? I guess we need good, old swithc measure for that ;). As far as dynamic labels
Dynamic Labels are wonderful addition to visualizations, however they are not fully optimized implemented.
- 😟 The blank values are not blank, but reverted back to original value (i know using transparent hex code is workaround, but then next point...)
- 😢 The label background is always set manually and cannot be dynamic
- 😭 The dynamic format is not working with dynamic labels, the setting within visual are always overriding the measure given format (unless FORMAT function is in works - not applicable with crazy nested SWITCHEs)
Hi Bas,
What is your take on Microsoft Fabric? and according to you how is it going to effect the current Power BI Developer roles or job opportunities?
Thanks,
Madhu.
Bass, there is nothing you can do to show negative values in YoY below the graph using these parameters?
Bas you're a damn wizard
☺️glad you like it!
Hi I really want you to make an video about Microsoft Fabric from scratch to end. How to completely use it like a series video. Please it really helps since its new no one knows how to use it.
we can manage it with Dynamic Format Strings for measures ?
Good video. How to have custom labels in waterfall chart? Pl guide.
Hi Bas,
After creating and adding these custom labels to chart, when the report is published to Power BI service the labels are not working properly, means they are not visible in the service.
I am facing this issue and please let me know any solution to overcome this.
Hi! Hope all is well - I am looking to create something similar but with month and week , I am having hard time to show the last weeks Data it only giving me just only one week . Any advice?
which kyeboard do you use bro?
Can you make a video on the Power Bi Ai Lens visual?
Good, good, good!
So far, what have you been thinking about on object feature?
How can I do it when I want to add budget data but I have group bar chart so I need different labeles for each data series?
No I disagree he shouldn’t get an MVP, there has to be something bigger than that. People are loving my reports, because of you Bas thanks for the amazing content.
hi... bas
how about with icon up and down or + and - into %tage
Is this the bar chart of the latest version of PowerBI? Or a custom visual ?
Its a combo chart ( column line ) :)
looking closer and closer to the version of SSRS 2005 but with responsive charts
Hi, I have a doubt my model size in 1.8GB (dax studio) but Im still able to publish my report in power bi service with PRO licensing
How is it possible?
Am I missing? something?
❤Thank you so much but can you guide me how to start from zero in power bi
czcams.com/video/w4NHK_jizUw/video.html
I cant find the custom label button in my power bi. I am using the latest version.
Always great content you're coming up with!
Btw, how did you quickly select the identical texts in your DAX measure czcams.com/video/J56xoO5tWhk/video.html ??
CRTL + D
Interesting thing.... custom labels do not allow to use emojis, icons, or unichar characters of any kind. I was trying to show some icons next to the labels for extra highlighting of outlier columns, but is not possible 😐
Hopefully, this is only not YET :)
I AM TRYING TO SIMPLY CHANGE THE LABEL FROM SOMETHING THAT IS A DROP DOWN,
Have you tried it with a "€" symbol. Its gives the me the ascii code.
1000 th like >.< , weird i m happy abt it
handsome..
Im sorry but you do not need all this. Focus on the data. To those who are reading this, you are not a graphic designer you are a data analyst.
To all reading this: the moment you create a visual you are designing