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!!!
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.
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.
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.
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 😔
Bas I love you man! You saved me a ton of times! I wanted to work for you but then I realize that "okay, who am I gonna copy for my work?". Thanks man!!!
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.
Hey Bass excellent once again. My questionis I have a bar chart that drills down 3 levels. How can the labelling be made interactive with the new name of categories as you drill down..
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.
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?
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
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 ☹️
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.
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 😅
hey mate its amazing, only caveat being if you dont turn off tool tip, the value for that dummy measure would appear as 0 right? Many times users would freak out looking at 0s.
Hi, thanks for the video ! Instead of creating measure for custom label for Subcategory, we could directly put Subcategory field in custom labels. This helps in not showing special characters issue like - &.
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
Thanks, it is very interesting! I have just one doubt about labels: is it possible to add values even if the measurement is based on a parameter (using 3 alternative measurements driven by a slicer)
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
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.
hey Bas! amazing and easy tutorial to follow :) however, how do you modify the bar spacing in the new version? I can't seem to find it since December's update
A classic one, half a second later I find what I asked about haha it's now under the Y-axis → Layout settings. Thanks anyways, love the content, you're a cool guy.
Amazing! I needed this! I am abviously the only one, but I am not getting the zero value from my placeholder. I do see it in the legend, but I don't get the extra space and I dont see anything when I add the custom label. Anyone an idea?
Same here. Been doing it over and over and over and even playing the video in slow motion in case I missed something. I'm using the December 2023 version. Help, anyone?
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 ?
Have they removed the option for conditional formatting on data labels? For some reason on an old visual I have the fx button but when recreating for a new visual it is gone.
Thank you so much, great content ❤❤❤ I am facing 1 issue if you get time or someone else here in the community to solve. If there's no value of any category the bar chart top showing blank area because the Y-Axis is available i just checked because as per your telling i set it off. How can i remove the blank area?
Your content is always awesome! Question: I´ve been struggling to conditional format the colors of a bar chart when there are 2 fields passed over the Y axis. Any clue on how to get through this? Thank you so much for this video!
thank you!!! i believe the option to conditionally format disappears when you have 2 or more measures. So as a work around you could use the error bars. The min and max you can set with measures so you could conditionally show the error bar.
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!
you would need to build IF logic into the label measure .. something like IF ( SELECTEVALUE ( dimGeo[City] ) , "City label text" , IF ( SELECTEVALUE ( dimGeo[Country] ) , "Country label text" , "Region label text" ))
I love your videos and can usually follow them. However on this one when I create the measure called labels placeholder and add it to the X axis, it will show in the legend but I do not see the "0" showing below the bar. This is a valuable hack and I would be grateful if you could tell me what I'm doing wrong.
I don't seem to have that option for my bar chart, I'm on the December version. Under Value decimal places, where you shorts vid shows the add custom label, I have Show blank as . Perhaps that replaced the custom label? I'd love to have this feature working!
@@skijunkiemom it looks a bit different now ( you have now more options ;) ). You can go to data labels, value, for field you can choose the label measure
When I add the dummy measure it does not show the value 0. Also when I don't have custom label but I have a field section under my values, and when I add the measure I created it still does not show
@@HowtoPowerBI when I use a pie chart the label text doesn't fit the size of the visual and, instead, ellipsis always appears: I always try to reduce the text, but the result is always terrible! Even when the visual is medium sized (a quarter of a sheet) 😮💨
My bar chart is showing only top 5 categories using numeric parameter, I can shown any number of top categories. When I put 0 in a measure and add that to bar chart , it give all of categories, instead of 5. is there any way to manage that?
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 think you could make that work as well :) .. instead of setting the dummy to 0, you take the value of the series you apply the labels to (here sales) .. then under formatting set the labels to inside base, no fill, no border, label overflow on, .. thats it :)
What do you mean by "drill-through" in label? The user can click on the bar right below the label and drill-through from there, which brings the filter (if enabled) on that label to the drill-through pqge.
@@dutch-man I meant that in the above video it's for one level of label to quote category wise sales What if I want to drill down to subcategory sales(as I wanted to show client both category and subcategory wise yearly monthly and weekly sales) As in y axis we can concatenate the labels which doesn't make sense all the time if there are many subcategories with larger names Hope you understand what I'm trying to get
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
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
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 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!” 😆
Dude, you are a creative genius at Power BI! That was awesome! Congratulations from Brazil!
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!!!
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.
Not only is the video great, the video editing is masterful! Amazing job!
Thanks!
I have no idea how you do it. So good with DAX and getting everything done. Mind Blowing!
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.
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
Awesome post, I used it today to show TotalOutput, ReprintTotal and percentage for each operator in a perfect way...looked awesome!!
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.
Yes you can .. use the fx button for the label colors :)
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 😔
Bas I love you man! You saved me a ton of times! I wanted to work for you but then I realize that "okay, who am I gonna copy for my work?". Thanks man!!!
That sooo nice to hear thank u!☺️ join then u will be better than me and then i can copy from u 🤓😁
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
This is absolutely class, have struggled with the space on these charts for years. thanks
Glad it was helpful! 😊
Hey Bass, any way of getting those labels left aligned?
Everyday I learn something new on this channel
I tried this today and it went well, thank you Bas.
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.
Hey Bass excellent once again. My questionis I have a bar chart that drills down 3 levels. How can the labelling be made interactive with the new name of categories as you drill down..
Another great solution to replace the out of the box bar chart with a way better-looking bar chart. Great video, Bas!!
Thanks! 👍
Hello Bas! Just wanted to check if this is still applicable as of today? I tried it but the CUSTOM LABEL under DATA LABELS cannot be found. Thank you
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.
Not even watched and already I like it. Great work. Gonna watch now :)
Lol 😊 hope u still like it after watching
Great video! Does this also work for stacked charts? Or any solution for those?
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?
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
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
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 ?
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.
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.
hey bas excellent work. but place holder labels are not visible in my case?
Excellent work and you are one of the best in dashboard designing and UI. Great work Bas
thanks a lot!
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
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 😅
The idea is great. I would like to do the same but using a Stacked Chart. Is this feasible?
This is amazing! However, I don't have the inner padding option in the Bars and Spacing option. Can anyone suggest what I could do about this?
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
hey mate its amazing, only caveat being if you dont turn off tool tip, the value for that dummy measure would appear as 0 right? Many times users would freak out looking at 0s.
Thanks! Just tested it- since there is no value, no tooltip shows (label doesnt triger tooltip either)
@@HowtoPowerBI Thats superb thanks mate
Hi, thanks for the video !
Instead of creating measure for custom label for Subcategory, we could directly put Subcategory field in custom labels. This helps in not showing special characters issue like - &.
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
Thanks Bas! This is really useful, but how is possible to use the labels on a hierachy in the same visual object
This was actually really good, i like attention to details
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)
Thanks, it is very interesting! I have just one doubt about labels: is it possible to add values even if the measurement is based on a parameter (using 3 alternative measurements driven by a slicer)
Yes you can!
Congrats Bas! Excellent work. How can we use it with hierarchy on one of the axis (store manager, district manager, country manager)? thank you
Amazing! How can I make this work using parameters in my bar chart?
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
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
Best PBI advanced instruction ❤
hey Bas! amazing and easy tutorial to follow :) however, how do you modify the bar spacing in the new version? I can't seem to find it since December's update
A classic one, half a second later I find what I asked about haha it's now under the Y-axis → Layout settings. Thanks anyways, love the content, you're a cool guy.
Amazing! I needed this!
I am abviously the only one, but I am not getting the zero value from my placeholder. I do see it in the legend, but I don't get the extra space and I dont see anything when I add the custom label. Anyone an idea?
Are you in July version?
Same here. Been doing it over and over and over and even playing the video in slow motion in case I missed something. I'm using the December 2023 version. Help, anyone?
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 ?
Have they removed the option for conditional formatting on data labels?
For some reason on an old visual I have the fx button but when recreating for a new visual it is gone.
Thank you so much, great content ❤❤❤
I am facing 1 issue if you get time or someone else here in the community to solve.
If there's no value of any category the bar chart top showing blank area because the Y-Axis is available i just checked because as per your telling i set it off. How can i remove the blank area?
Cool, but how made round corner of columns histogram?
hm, you probably could do it by adding error bars .. set the position equal to the column value .. change the marker to circle and increase the size
Your content is always awesome!
Question: I´ve been struggling to conditional format the colors of a bar chart when there are 2 fields passed over the Y axis.
Any clue on how to get through this?
Thank you so much for this video!
thank you!!! i believe the option to conditionally format disappears when you have 2 or more measures. So as a work around you could use the error bars. The min and max you can set with measures so you could conditionally show the error bar.
your videos come at the right time in my feed tons of thanks bas
This guy seems to amaze me every time
🙏 thanks for the nice comment :)
Simply Awesome, dont find better words to explain
Thank you so much 😀
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 helpful, great video. Is it possible to do something similar with a clustered bar chart ?
Great Video, Unfortunately not working with my bar graph, what could go wrong?
I have crated lables measure but not reflecting in bar graph,
maybe check against the file of the video to see what you did differently (see description for the download link)
Use a Clustered Bar Chart - not a Stacked Bar Chart
Awesome Trick. Thanks for the video.
Can we do the same for Stacked Column Chart. I tried and it doesn't work.
Is there a way to do this when drilling down to another level?
Thanks Bas. If my chart has grill down function, say Region > Country > City. How shall I define the label measure?
you would need to build IF logic into the label measure .. something like IF ( SELECTEVALUE ( dimGeo[City] ) , "City label text" , IF ( SELECTEVALUE ( dimGeo[Country] ) , "Country label text" , "Region label text" ))
I love your videos and can usually follow them. However on this one when I create the measure called labels placeholder and add it to the X axis, it will show in the legend but I do not see the "0" showing below the bar. This is a valuable hack and I would be grateful if you could tell me what I'm doing wrong.
sounds like you missed a step. Under label formatting options make sure you have the correct series selected and then add custom labels.
I don't seem to have that option for my bar chart, I'm on the December version. Under Value decimal places, where you shorts vid shows the add custom label, I have Show blank as . Perhaps that replaced the custom label? I'd love to have this feature working!
@@skijunkiemom it looks a bit different now ( you have now more options ;) ). You can go to data labels, value, for field you can choose the label measure
i try this, but it does not work when you have a graphic with a field of counts. :( or im missing something?
Regards!
should also work :)
Looks nice, but what if bar chart has to have a legend? Applied legend kinda blocks me from adding labels placeholder
Thanks for this wonderful video. How to do this in 100% stacked bar chart ? Can you please make a video for this ?
Amo a este hombre, gracias.
Thank you Bas, no more need on using custom visualizations :)
Awesome :)
Hey, is it possible to make number colors change using a measure, when I have different columns data appearing on the same bar?
the Best powerbi guy in the world
Amazing video. Thanks for sharing this.
When I add the dummy measure it does not show the value 0. Also when I don't have custom label but I have a field section under my values, and when I add the measure I created it still does not show
if you figure it out please let me me I'm facing the same issue
Congrats for the video, Bas!!! I have the same problem with pie charts - do you have a solution for those too? 🙃
what are you trying to achieve with the pies ?
@@HowtoPowerBI when I use a pie chart the label text doesn't fit the size of the visual and, instead, ellipsis always appears: I always try to reduce the text, but the result is always terrible! Even when the visual is medium sized (a quarter of a sheet) 😮💨
My bar chart is showing only top 5 categories using numeric parameter, I can shown any number of top categories.
When I put 0 in a measure and add that to bar chart , it give all of categories, instead of 5.
is there any way to manage that?
Fantastic, but...I´m using bigger strings and text is hidden. What is the solution?
Bas once again amazing work / tip / trick / magic!!. Thanks a lot this was a this was a headache.
Is it possible to do it for a Stacked Bar Chart?
How to create a bar chart similar to the top 5 products? Is there something wrong when using with top products? Pls help me!
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 :)
Are you a wizard? Great idea and so easy to do, thanks!
As usual, great content for us from the finest person... keep rocking 😎
😊😎👊 thank you Kumar !!!!
can this trick be done using stack bar charts?
I love your tweaks !! it helped me on so many cases..💯
Cool!! Happy to hear it :)
Thanks. I'll just go with the first thing you showed me, which is simply increase the width of the label. Good enough.
Mastery of a master in dataviz
😊
Great technique, thanks for sharing all this knowledge
Glad it was helpful!
hey Bass can you suggest what to do if we want to use drill-down in labels as well
I think you could make that work as well :) .. instead of setting the dummy to 0, you take the value of the series you apply the labels to (here sales) .. then under formatting set the labels to inside base, no fill, no border, label overflow on, .. thats it :)
What do you mean by "drill-through" in label? The user can click on the bar right below the label and drill-through from there, which brings the filter (if enabled) on that label to the drill-through pqge.
@@dutch-man
I meant that in the above video it's for one level of label to quote category wise sales
What if I want to drill down to subcategory sales(as I wanted to show client both category and subcategory wise yearly monthly and weekly sales)
As in y axis we can concatenate the labels which doesn't make sense all the time if there are many subcategories with larger names
Hope you understand what I'm trying to get
Absolutely top notch stuff Bas. Love sll your vids and way you explain all the corner cases. ❤❤
Glad you like it!
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 ;)
How can I create stacked round corners column charts?