MASTERING Bar Charts in Power BI | No more Cut Labels

Подписаться 209 тыс.

Просмотров 94 тыс.

50% 1

In this video I walk you through my approach to dealing with axis labels that do not show fully due to lack of space. With a few tricks it is possible to show labels above each bar. This is super helpful especially when you have long item names or would like to incorporate additional information into the labels.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
Learn how I build my Power BI reports and join me in the upcoming Power BI Design training!
my.datatraining.io/pages/powe...
--------------------------------
📊 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
00:47 Standard way of dealing with long axis labels
01:36 Adding label placeholders above each bar
03:31 Show labels above the bars
05:28 Making the new labels look better
08:08 Exploring the positioning of the value label
10:58 Can we include unichars?
12:46 Applying conditional formatting to the labels
14:02 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 RU-vid: 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

Наука

Опубликовано:

22 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 300

@tianyuzhao5385 6 месяцев назад

Hi Bas! Just want to say a deep thank you for all the videos you have been posting. I am trying to watch all of them haha, quite challenging but out of each one, you teach me some very nice visualization tricks for the monthly KPI report I am doing and different powerBI tools I designed for operation (I work in logistics). Your out of box thinking is really amazing and something I cannot find elsewhere. Please keep up the good work like always and bear in mind each video you released benefit so much people out in the world that you can’t possibly imagine❤

@Lottumracing 8 месяцев назад

Awesome post, I used it today to show TotalOutput, ReprintTotal and percentage for each operator in a perfect way...looked awesome!!

@michelcesar85 8 месяцев назад

Dude, you are a creative genius at Power BI! That was awesome! Congratulations from Brazil!

@nawafsharaf 8 месяцев назад

Excellent idea Bas! Lots of attention to detail. This has been my headache for pas 2-3 years. Now we do all these and boss say “switch to pie chart!” 😆

@richardmartin7904 8 месяцев назад

Again top tier content. You would make an excellent professor with logical, clear, well thought out explanations. I love that you deliberately spend time explaining anything and everything that can go wrong.

@HowtoPowerBI 8 месяцев назад

so nice to hear that! thanks a lot

@farhatwajidkhan 8 месяцев назад

I have no idea how you do it. So good with DAX and getting everything done. Mind Blowing!

@SimplyUnsafe 8 месяцев назад

This has been a major pain point for me in Powerbi! My solution was to create a crosswalk of shortened/abbreviated category names to get the whole value to fit in a barchart, but I like this solution much better. Its very clean and easier to maintain (ie, in my solution I'd have to watch for new categories appearing to create a new abbreviation). Thank you for your videos, you always have such creative workarounds to the limitations in PBI.

@user-yd1kv4xc2s 8 месяцев назад

your videos come at the right time in my feed tons of thanks bas

@sanumpzha 8 месяцев назад

I tried this today and it went well, thank you Bas.

@Alan-eb6gp 4 месяца назад

This is absolutely class, have struggled with the space on these charts for years. thanks

@HowtoPowerBI 4 месяца назад

Glad it was helpful! 😊

@ShovanMandal 8 месяцев назад

I love your tweaks !! it helped me on so many cases..💯

@HowtoPowerBI 8 месяцев назад

Cool!! Happy to hear it :)

@tobydoane 3 месяца назад

Fantastic lesson. Thank you!

@devashishjain5493 8 месяцев назад

Finally the old excel features are showing up. Great video, would have loved to see the interaction with other visuals, whether they mess up or not. Probably not, but I just have urge to test. Thanks Bas.

@jahmed525 8 месяцев назад

Absolutely top notch stuff Bas. Love sll your vids and way you explain all the corner cases. ❤❤

@HowtoPowerBI 8 месяцев назад

Glad you like it!

@ohdang8515 8 месяцев назад

This is a great video. Absolutely wild that this isn't out of the box functionality and requires so many additional hoop-jumps to execute.

@HowtoPowerBI 8 месяцев назад

Agreed… hopefully soon

@jaymehta3320 8 месяцев назад

Amazing video. Thanks for sharing this.

@sameera0612 Месяц назад

Brilliant approach!

@datayoda74 8 месяцев назад

Excellent work and you are one of the best in dashboard designing and UI. Great work Bas

@HowtoPowerBI 8 месяцев назад

thanks a lot!

@D4rkm00r 8 месяцев назад

Your wizardry is next level. Thanks Bas! EDit: Just to add, i produce dashboards for a client that is present in only a handful of sub-categories at most so this method looks clean, concise and adheres to UI/UX principles perfectly. Amazing work.

@HowtoPowerBI 8 месяцев назад

Thanks for watching

@jemk5000 8 месяцев назад

Gracias, excelente trabajo como siempre.

@tubeitz 8 месяцев назад

This is another level! thanks mate

@muhammetmuslu4429 8 месяцев назад

It was exactly what I was looking for thank you very much

@DatawithHimanshu 8 месяцев назад

Top notch content as usual. Thank you 😊

@AndresFelipeCastrillonValencia 4 месяца назад

Great technique, thanks for sharing all this knowledge

@HowtoPowerBI 4 месяца назад

Glad it was helpful!

@MrAszpic 8 месяцев назад

It looks surprisingly clean! Neat for when you've got few categories or want to fill extra vertical space

@HowtoPowerBI 8 месяцев назад

yea exactly as long as you don't have super many items it is worth considering this alternative - thanks for watching again! :D

@armsotopre 8 месяцев назад

Thanks for your help, you video are very concrete to learning

@josefedericopresno6668 8 месяцев назад

Another great video, Thanks a lot, Bas. Always learning from You.

@HowtoPowerBI 8 месяцев назад

I appreciate that! thanks for watching Jose

@hermesjrd 8 месяцев назад

As always a great insight, thanks

@adilmajeed8439 8 месяцев назад

Simply Awesome, dont find better words to explain

@HowtoPowerBI 8 месяцев назад

Thank you so much 😀

@mohammadaamirkhan7830 7 месяцев назад

Wow! Amazing video Thank you

@Abdallahmohamed-wn9fb 6 месяцев назад

Everyday I learn something new on this channel

@arbazahmad7177 8 месяцев назад

Excellent technique 👌......Thanks for sharing amazing content.

@HowtoPowerBI 8 месяцев назад

Thank you! Cheers! :D

@Sisi-vp7xs 7 месяцев назад

Best PBI advanced instruction ❤

@chukachukwu 8 месяцев назад

Another great video, thanks Bas for all the great work u do

@HowtoPowerBI 8 месяцев назад

:D thank you!!! very happy to hear that :D

@chukachukwu 8 месяцев назад

Fantastic stuff Bas, used this today in a project. I tweaked your measure a bit so It worked with a field parameter. Great stuff

@kumarvg5383 8 месяцев назад

As usual, great content for us from the finest person... keep rocking 😎

@HowtoPowerBI 8 месяцев назад

😊😎👊 thank you Kumar !!!!

@srinupampana3814 8 месяцев назад

Brilliant solution for the Labelling. ❤ Thanks for your Awesome solutions in Power BI

@HowtoPowerBI 8 месяцев назад

thank you for watchn!!! :D

@srinupampana3814 8 месяцев назад

Boss, Can you make a video on dynamic colum headers in Matrix visual when we are using the Measures as Values in Matrix.

@juanignacioXI 6 месяцев назад

Bas once again amazing work / tip / trick / magic!!. Thanks a lot this was a this was a headache.

@AB-ox8ln 7 месяцев назад

Amo a este hombre, gracias.

@fenrir433 8 месяцев назад

love this idea! i also use Data bars in matrix visuals to also reach the same point.

@hasnainakram1530 8 месяцев назад

great content as always. Thanks :)

@scottwilliams6741 8 месяцев назад

Another great solution to replace the out of the box bar chart with a way better-looking bar chart. Great video, Bas!!

@HowtoPowerBI 8 месяцев назад

Thanks! 👍

@jessontvarghese327 8 месяцев назад

This is super cool Bas.. You are awesome. Thank you...

@HowtoPowerBI 8 месяцев назад

Glad you like it! thx for watching!!! :D

@leegarrett1908 8 месяцев назад

Not even watched and already I like it. Great work. Gonna watch now :)

@HowtoPowerBI 8 месяцев назад

Lol 😊 hope u still like it after watching

@alexkim7270 8 месяцев назад

I literally just thought about this a few hours ago. Thank you!

@HowtoPowerBI 8 месяцев назад

i'm reading your mind ... or your mine ! :D

@lorenzoladejobi8701 5 месяцев назад

Very educative!

@mathaem 8 месяцев назад

Thank you Bass ! An amazing video again ^^

@HowtoPowerBI 8 месяцев назад

😎👊😊 thank you for watching it !!!

@ALEXMELO1234 8 месяцев назад

You are great! Very smart solution!

@HowtoPowerBI 8 месяцев назад

Thanks Alex! 🙏

@naimuddinsiddiqui9249 7 месяцев назад

Amazing ! You are giving a new vision your dedication toward Community Unremarkable .Your content take me to next level in power Advance Journey. However One concern I have checked in power bi service level Custom label not displaying the Labels for this scenario if you have any workaround pls do let me know.

@GentilOliveira 8 месяцев назад

Great job. Thanks for share.

@HowtoPowerBI 8 месяцев назад

Thanks for watching! 😊

@viniciusfranciscodeoliveir432 8 месяцев назад

Thank you Bas, no more need on using custom visualizations :)

@HowtoPowerBI 8 месяцев назад

Awesome :)

@syedyakub5849 8 месяцев назад

Thank you bas, informative video ❤

@HowtoPowerBI 8 месяцев назад

happy to hear that you got some value from it 😊 thanks for watching

@garryelsdon6296 2 месяца назад

Excellent presentation. Very clear and easy to understand and follow. My challenge is how can you make the labels dynamic. For example if there was more than 1 field in the bar chart and you used the drill down filter how could you get the the labels to also change.

@parthibanselvam4997 8 месяцев назад

Wow.. wonderful 👍 going implement for my current report

@HowtoPowerBI 8 месяцев назад

Awesome let me know how it goes

@parthibanselvam4997 8 месяцев назад

@@HowtoPowerBI works well 👍👍

@grl4171 8 месяцев назад

If you dont need drillthrough or custom tooltips, the horizontal barchart custom visual is easier for this approach. You can switch from hammer head, lollipop, line... But nice content, very usefull :)

@Malachiasz1983 8 месяцев назад

Great tutorial and awesome usage of measures and nuances of Power BI. On the other hand it is crazy that UI change that should be 2 clicks away, natively in Power BI, requires 15 minutes tutorial to implement.

@HowtoPowerBI 8 месяцев назад

Totally agree

@edwinarchico439 8 месяцев назад

Very interesting and useful keep it up Bas

@HowtoPowerBI 8 месяцев назад

Thanks! Glad you think so!

2 месяца назад

Simply, thank you!

@HowtoPowerBI 2 месяца назад

😊

@mariapradeepm 8 месяцев назад

This is just amazing as usual from you!! How do you really think and come up with this??? Just awesome, looking forward to hear from you.

@HowtoPowerBI 8 месяцев назад

:):) thanks a lot, looking at ways to improve the reports and just clicking around (a looot of it)

@vibhudhyani9466 8 месяцев назад

Simply genius ❤️

@HowtoPowerBI 8 месяцев назад

@nash_life 8 месяцев назад

Love you man amazing. Thank you so much. Gold.

@HowtoPowerBI 8 месяцев назад

😎👊

@miguelbenito7992 8 месяцев назад

Thanks Bas! Awesome 😎

@HowtoPowerBI 8 месяцев назад

😎😊😎👊

@isteaq993 8 месяцев назад

Thanks a lot, I was looking for it & it is appeared 😌. Though it seems hard for me but still thanks a lot❤

@HowtoPowerBI 8 месяцев назад

You can do it!

@mohitupadhayay1439 8 месяцев назад

Bass! People are going to remember you for millions of years to come pal. Please make some Udemy courses too. Folks can benefit a lot from your courses.

@HowtoPowerBI 8 месяцев назад

thanks a lot! I tried udemy, but was not able to get a lot of exposure on the platform. You can therefore find my courses on datatraining.io/powerbi-training

@D4rkm00r 8 месяцев назад

@@HowtoPowerBI I use a lot of Maven course on Udemy in conjunction with your work here. Such a shame you didn't get traction. I'll absolutely pick up a few of your courses. Muchos gracias for everything you do.

@sandipjabade1 26 дней назад

@@HowtoPowerBI you are charging $2750 for a course , it's not affordable if we compare with udemy price it's too huge

@HowtoPowerBI 25 дней назад

@@sandipjabade1 the power bi essentials learning path is 30 usd, maybe that is more interesting to you. The design transformation is not comparable to any udemy course.

@ymohamed3154 8 месяцев назад

Excellent👌👍

@nahuelvalenzuela5143 8 месяцев назад

Great Video! tks!

@HowtoPowerBI 8 месяцев назад

Glad you liked it! thx!

@grumpyae86 27 дней назад

Great stuff

@HowtoPowerBI 27 дней назад

Thank you!!! 😊

@satyawannishadms-powerplat6938 8 месяцев назад

Love to watch your videos ❤❤

@HowtoPowerBI 8 месяцев назад

thank you for watching them :D

@SergiuTULUC-ev2qx 2 месяца назад

perfect! almost.. looks a little bit different in case of negatives

@paulmoffatt4325 7 месяцев назад

Awesome!

@mayursharma3980 8 месяцев назад

Very helpful, great video. Is it possible to do something similar with a clustered bar chart ?

@user-kq6xz4bs9w 8 месяцев назад

Are you a wizard? Great idea and so easy to do, thanks!

@madhan7390 8 месяцев назад

You are Awesome 👏🏻

@HowtoPowerBI 8 месяцев назад

😊 thanks for watchn

@renatomoreira4498 8 месяцев назад

Congrats Bas! Excellent work. How can we use it with hierarchy on one of the axis (store manager, district manager, country manager)? thank you

@zuzanabocanski6580 8 месяцев назад

Thanks!

@info2satish 8 месяцев назад

Simply brilliant! Love from Bharat ❤

@HowtoPowerBI 8 месяцев назад

thank you!!! :D .. love back from Düsseldorf ;)

@vihasharma7883 8 месяцев назад

You are an absolute genius

@HowtoPowerBI 8 месяцев назад

i wish :D

@KhangTran3011 8 месяцев назад

a brilliant trick 👍🏻

@HowtoPowerBI 8 месяцев назад

thank you!!!

@Saif_Ali_Khan_1301 Месяц назад

the Best powerbi guy in the world

@narasimhaprasad847 8 месяцев назад

Excellent ....!!!

@HowtoPowerBI 8 месяцев назад

😊

@AHMEDALDAFAAE1 8 месяцев назад

This is cool! However, you can simply add a Category name to the X-axis beside Sales (X-axis will contain both) and keep the Category name in Y-axis then enable Custom label = Category name, and finally enable total label, and with some tweaking it will work

@SpaceMusicOutofWorld 8 месяцев назад

YOU'RE HERO!

@nilsreger8222 Месяц назад

Great video! Does this also work for stacked charts? Or any solution for those?

@nusretmuharrem6418 8 месяцев назад

this is amazing ...

@HowtoPowerBI 8 месяцев назад

Thanks :)

@rigantemario 6 месяцев назад

Hi Bas, first of all very nice video. Quick suggestion from your end. If I have a hierarchical bar chart with different data once I drill down how can I make it works? What I have in mind is defining a measure which first check the data and then define the selectedvalue() to be displayed on top to the bar. Something like: If data(1) then selectedvaue(x) else if data(2) then selectedvalue(y) etc. Do you have a way forward. Thanks a lot

@jecwonch 8 месяцев назад

This guy seems to amaze me every time

@HowtoPowerBI 8 месяцев назад

🙏 thanks for the nice comment :)

@khajvand 8 месяцев назад

Useful 👍

@Rajivinc 8 месяцев назад

The G.O.A.T! 🔥

@luisfernandomacedo1451 8 месяцев назад

Mastery of a master in dataviz

@HowtoPowerBI 8 месяцев назад

😊

@nansijosey 8 месяцев назад

Amazing! How can I make this work using parameters in my bar chart?

@marianaalves2598 8 месяцев назад

The idea is great. I would like to do the same but using a Stacked Chart. Is this feasible?

@sanumpzha 8 месяцев назад

Wowow.. nice one..🤟

@HowtoPowerBI 8 месяцев назад

Thanks 🤗

@user-sj9xz2wm7f 8 месяцев назад

Another amazing work. However, the labels do not work properly if I want to see Year To Date bar chart and filter by different month. Can you look into this problem? or there is no way we can do with that?

@deathgodryuk12 5 месяцев назад

Great video Bas! This makes the chart neat. Unfortunately, I got lost @5:55. I can't see these padding and width that you adjusted. I am only seeing 'Space between categories' which is not enough to make the labels look ok 😔

@eclipse-299 3 месяца назад

Hello, love your contents so much as it is really helping me !, in this video though I noticed you have more control over the formatting the bars which I don't have in my power BI desktop even though it is the latest version of Power BI, for instance I also need to play around with the "Inner padding" option under Bars under "Spacing" in the formatting menu but I don't have that one I have just the ability to change the spacing between the bars , do you may be know what might be the reason for that ?

@zinnour 8 месяцев назад

Good Job

@HowtoPowerBI 8 месяцев назад

Thank you!!! :D

@HowtoPowerBI 8 месяцев назад

Yes you can .. use the fx button for the label colors :)

@unnikrishnansanthosh 8 месяцев назад

oops! this is out of the world, thank you for sharing BAS

@anoopdube9581 8 месяцев назад

Fantabulous

@HowtoPowerBI 8 месяцев назад

thank you!!! 😊

@user-ch3bo9hn5k 8 месяцев назад

Amazing

@HowtoPowerBI 8 месяцев назад

😎😊😁

@LeeForsythe 8 месяцев назад

Great video. It’s a real shame that Microsoft isn’t investing time and money into improving visuals. This is a very basic feature imo that should come out of the box. If you look at some of the out of the box features that come with datadog (I understand that’s a monitoring tool but it’s still a data visualisation tool) it really highlights how behind Microsoft are in visualisation. I love power bi but it takes too long to create something visually appealing when it doesn’t really need to.