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.
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.
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!” 😆
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❤
Again, another amazing video I stumbled on trying to make my bar charts better looking! Idk if I couldn't follow along well enough but it looks like the latest versions of PBI no longer have the custom labels feature you demo'd at 4:23. Regardless, amazing video thank you so much for the guidance!!!
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.
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.
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
@@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 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.
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.
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.
This has helped me massively, thanks! Just one question, maybe someone has already asked it. If i have a drill down on a bar chart, is there a way to switch the labels to show the lower level category names?
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.
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.
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 :)
I was trying it but this doesn't seem to work for me. I'm clueless. When I'm putting the label placeholder= 0 in my bar chart, nothing changes except the colour of bars. The width of bars remains the same and the bars don't show the value "0" above them. I don't know what to do now ☹️
This looks great! I’m trying to get this to work in combination with fileld parameters. The user can then choose the column on the axis and the label shows the names. I cannot get this to work. Maybe something for a future video 😅
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
I think you should rename your channel 'How to fix the blatantly obvious shortcomings of Power BI for visualization'. Huge fan of Power BI, but its visualization capabilities are just too poor after all these years.
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.
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 😔
Hi there, thanks grate video. What I can do is I have a category that don't have a value? I I don't want to get display as a category if the value is zero? Really appreciated if you can explain? Thanks
Hello! thanks a lot for the video. I have got a query. I'm using Infographic Designer for one of my use cases where I am required to use Small Multiples. To make the graphs 508 compliant, I would want to use fill patterns for the bar graphs, but Infographic designer doesn't offer one. Could you please suggest how to go about resolving this? Thanks!
Thanks for this, very insightful. I tried it for one of my reports and it worked, am trying to do same again and I can't navigate the custom label in the data label value section, its not there anymore, is there another way to navigate through this.
thanks for watching! :) i think with dax it is all about knowing some key principles. There are however some patterns that come back a lot. I would create your own little library of code snippets that you can adjust to your own reports.
@@HowtoPowerBI Thanks in advance, I am working on a pilot of power BI initiation in copper and gold mine. So, our section is in early stage of using Power BI
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.
so nice to hear that! thanks a lot
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.
Thanks for watching
This was actually really good, i like attention to details
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!” 😆
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❤
Dude, you are a creative genius at Power BI! That was awesome! Congratulations from Brazil!
Again, another amazing video I stumbled on trying to make my bar charts better looking! Idk if I couldn't follow along well enough but it looks like the latest versions of PBI no longer have the custom labels feature you demo'd at 4:23. Regardless, amazing video thank you so much for the guidance!!!
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.
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.
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
@@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.
@@HowtoPowerBI you are charging $2750 for a course , it's not affordable if we compare with udemy price it's too huge
@@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.
I tried this today and it went well, thank you Bas.
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.
Agreed… hopefully soon
Yes you can .. use the fx button for the label colors :)
This is absolutely class, have struggled with the space on these charts for years. thanks
Glad it was helpful! 😊
Everyday I learn something new on this channel
I have no idea how you do it. So good with DAX and getting everything done. Mind Blowing!
Hey Bass, any way of getting those labels left aligned?
Awesome post, I used it today to show TotalOutput, ReprintTotal and percentage for each operator in a perfect way...looked awesome!!
Simply Awesome, dont find better words to explain
Thank you so much 😀
Brilliant solution for the Labelling. ❤ Thanks for your Awesome solutions in Power BI
thank you for watchn!!! :D
Boss, Can you make a video on dynamic colum headers in Matrix visual when we are using the Measures as Values in Matrix.
Amazing video. Thanks for sharing this.
Excellent work and you are one of the best in dashboard designing and UI. Great work Bas
thanks a lot!
6:12 In the current version of Power BI, there is no option for spacing in the bars category. Now how do we increase the space between both the bars?
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.
Not even watched and already I like it. Great work. Gonna watch now :)
Lol 😊 hope u still like it after watching
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.
Great technique, thanks for sharing all this knowledge
Glad it was helpful!
your videos come at the right time in my feed tons of thanks bas
Best PBI advanced instruction ❤
Thank you! Very useful.
Glad to hear that!
I love your tweaks !! it helped me on so many cases..💯
Cool!! Happy to hear it :)
This has helped me massively, thanks! Just one question, maybe someone has already asked it. If i have a drill down on a bar chart, is there a way to switch the labels to show the lower level category names?
I'm curious about this as well
Bas once again amazing work / tip / trick / magic!!. Thanks a lot this was a this was a headache.
As usual, great content for us from the finest person... keep rocking 😎
😊😎👊 thank you Kumar !!!!
It looks surprisingly clean! Neat for when you've got few categories or want to fill extra vertical space
yea exactly as long as you don't have super many items it is worth considering this alternative - thanks for watching again! :D
Thanks for your help, you video are very concrete to learning
Another great video, Thanks a lot, Bas.
Always learning from You.
I appreciate that! thanks for watching Jose
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.
:):) thanks a lot, looking at ways to improve the reports and just clicking around (a looot of it)
Another great solution to replace the out of the box bar chart with a way better-looking bar chart. Great video, Bas!!
Thanks! 👍
Absolutely top notch stuff Bas. Love sll your vids and way you explain all the corner cases. ❤❤
Glad you like it!
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.
Thank you Bas, no more need on using custom visualizations :)
Awesome :)
This guy seems to amaze me every time
🙏 thanks for the nice comment :)
Another great video, thanks Bas for all the great work u do
:D thank you!!! very happy to hear that :D
Fantastic stuff Bas, used this today in a project. I tweaked your measure a bit so It worked with a field parameter. Great stuff
Fantastic lesson. Thank you!
Excellent technique 👌......Thanks for sharing amazing content.
Thank you! Cheers! :D
I literally just thought about this a few hours ago. Thank you!
i'm reading your mind ... or your mine ! :D
Brilliant approach!
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.
Totally agree
This is super cool Bas.. You are awesome. Thank you...
Glad you like it! thx for watching!!! :D
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 :)
I was trying it but this doesn't seem to work for me. I'm clueless. When I'm putting the label placeholder= 0 in my bar chart, nothing changes except the colour of bars. The width of bars remains the same and the bars don't show the value "0" above them. I don't know what to do now ☹️
He's using a clustered bar chart. If you use a stacked barchart it will put the dummy measure in front (or behind) the actual data bar.
This looks great! I’m trying to get this to work in combination with fileld parameters. The user can then choose the column on the axis and the label shows the names. I cannot get this to work. Maybe something for a future video 😅
perfect! almost.. looks a little bit different in case of negatives
It was exactly what I was looking for thank you very much
Great video! Does this also work for stacked charts? Or any solution for those?
Thank you Bass ! An amazing video again ^^
😎👊😊 thank you for watching it !!!
Top notch content as usual. Thank you 😊
Amo a este hombre, gracias.
You are great! Very smart solution!
Thanks Alex! 🙏
I will try this out
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
the Best powerbi guy in the world
love this idea! i also use Data bars in matrix visuals to also reach the same point.
Simply brilliant! Love from Bharat ❤
thank you!!! :D .. love back from Düsseldorf ;)
Simply genius ❤️
:)
This is another level! thanks mate
I think you should rename your channel 'How to fix the blatantly obvious shortcomings of Power BI for visualization'. Huge fan of Power BI, but its visualization capabilities are just too poor after all these years.
haha lol :p yea, it doesn't have the flexibility like tableau has .. but there is a whole hype around new visual updates that are coming ... so lets c
@@HowtoPowerBI looking forward to that too... based on your comment you were not involved? That's a shame
Are you a wizard? Great idea and so easy to do, thanks!
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.
Mastery of a master in dataviz
😊
You are Awesome 👏🏻
😊 thanks for watchn
You are an absolute genius
i wish :D
Gracias, excelente trabajo como siempre.
Wow.. wonderful 👍 going implement for my current report
Awesome let me know how it goes
@@HowtoPowerBI works well 👍👍
Thank You Boss for another informative video.🗯🗯🗯
thanks for watching!!! 😊 ( you can call me bas 😋😉 )
Thanks a lot, I was looking for it & it is appeared 😌. Though it seems hard for me but still thanks a lot❤
You can do it!
As always a great insight, thanks
Wow! Amazing video
Thank you
Great stuff
Thank you!!! 😊
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 😔
Simply, thank you!
😊
oops! this is out of the world, thank you for sharing BAS
Thank you bas, informative video ❤
happy to hear that you got some value from it 😊 thanks for watching
Awesome Trick. Thanks for the video.
Can we do the same for Stacked Column Chart. I tried and it doesn't work.
Hi..How can we put the labels on top of the bars for Stacked Bar chart visual ? In this particular visual, we can apply only 1 field or measure!
if you figure it out please let me me I'm facing the same issue
great content as always. Thanks :)
Love to watch your videos ❤❤
thank you for watching them :D
Hi there, thanks grate video. What I can do is I have a category that don't have a value? I I don't want to get display as a category if the value is zero? Really appreciated if you can explain? Thanks
Hello! thanks a lot for the video. I have got a query. I'm using Infographic Designer for one of my use cases where I am required to use Small Multiples. To make the graphs 508 compliant, I would want to use fill patterns for the bar graphs, but Infographic designer doesn't offer one. Could you please suggest how to go about resolving this? Thanks!
Very educative!
Thanks for this wonderful video. How to do this in 100% stacked bar chart ? Can you please make a video for this ?
This was a great tip, I wonder why you didn't put the label inside the bar, I have recently done in one of my Dashboard ?
Thanks for this, very insightful. I tried it for one of my reports and it worked, am trying to do same again and I can't navigate the custom label in the data label value section, its not there anymore, is there another way to navigate through this.
Try switching the visual to line chart, apply the custom label then switch back to bar chart
You're a genius bro
i wish :p but i do know how to put the labels above a bar chart lol :D
Fantastic, but...I´m using bigger strings and text is hidden. What is the solution?
Great job. Thanks for share.
Thanks for watching! 😊
Such a helpful guidance!
Any tips to faster remember the measure code?
thanks for watching! :) i think with dax it is all about knowing some key principles. There are however some patterns that come back a lot. I would create your own little library of code snippets that you can adjust to your own reports.
@@HowtoPowerBI Thanks in advance, I am working on a pilot of power BI initiation in copper and gold mine. So, our section is in early stage of using Power BI
@@ljgaming1589 maybe this end user training would help you with the iniation of pbi
Love you man amazing. Thank you so much. Gold.
😎👊
hey bas excellent work. but place holder labels are not visible in my case?
Is there a way to do this when drilling down to another level?