In the interest of full transparency, I'd like to acknowledge the inspiration behind the trick of displaying of the category name above the series bar in this chart which I implemented with a different approach. This idea was primarily inspired by the innovative content from @HowtoPowerBI, who continually inspires creators within our community. Regrettably, I forgot to mention it in the video. I believe in giving credit where it's due, and @HowtoPowerBI deserves recognition for their ideas.
Thank you so much for this precious learning video, i have done it. But having 1 issue i dont know how do i resolve. I created this for category. But when i click on year where all categories are not available the chart top area showing blank. Because of Y Axis available where i did Y Axis off.
I tried this approach on July 2024 and the Custom label is disabled. for those with the same issue I was able to solve adding a dynamic title (Data Label > Series: Whole > Title > Custom > Segment label measure ) and disabling the value of the Whole measure label.
It doesn’t seem to work as I expected. When there are fewer than five categories, the bars become too spaced apart. If you try to reduce the gap, the main bar will increase in size, causing it to overlap with the error bar, which is limited to a maximum of 10px. Another issue is that if a new category is added to the data, you'll need to adjust everything again.
Hi, Thank you very nice explanation but I have a question? What happen if I one of the categories did have a value for the period? I try to apply this technique but it still showing the category with the non value, how i can fix this, if I don't want the category there just the ones with values
I had the same issue. I got around it by wrapping an if statement around the base 0 measure to leave it null if my x axis value is not > 0. in my case it is for income so my base 0 measure is: Income Base 0 = IF([Income] > 0, 0)
I resolved this in PBI August 2024 version by following the similar procedure OP showed in the video utilizing the Dynamic Measure. In other words, when looking at the format of the Whole measure it displayed "0%;-0%;0%" which I replaced with " " to essentially make the measure empty and 100% no longer appeared on the bar 😊
In the interest of full transparency, I'd like to acknowledge the inspiration behind the trick of displaying of the category name above the series bar in this chart which I implemented with a different approach. This idea was primarily inspired by the innovative content from @HowtoPowerBI, who continually inspires creators within our community. Regrettably, I forgot to mention it in the video. I believe in giving credit where it's due, and @HowtoPowerBI deserves recognition for their ideas.
Love this and the explanation in the comments below. Well deserved click on the Subscribe button! :D Thank you!
this worth gold! thank you for the video and the awesome teaching
Thanks you! super clear and super usefull
Love it! Thanks
You are so welcome!
Absolutely stunning 🎉.. thanks
You’re welcome 😊
Thank you so much for this precious learning video, i have done it. But having 1 issue i dont know how do i resolve. I created this for category. But when i click on year where all categories are not available the chart top area showing blank. Because of Y Axis available where i did Y Axis off.
One workaround for this scenario is to create a measure and assign it to the visual filter to hide the category when there is no data.
Well explained. Thanks for sharing 🎉
My pleasure 😊
Excelent...really helped. It would be nice to have a .pbix file to practice more scenarios
I tried this approach on July 2024 and the Custom label is disabled. for those with the same issue I was able to solve adding a dynamic title (Data Label > Series: Whole > Title > Custom > Segment label measure ) and disabling the value of the Whole measure label.
Congratulations on the video, follow all the steps in the video, but the graph is not the same, the edges still remain. How do I resolve it?
Resize the chart
It doesn’t seem to work as I expected.
When there are fewer than five categories, the bars become too spaced apart. If you try to reduce the gap, the main bar will increase in size, causing it to overlap with the error bar, which is limited to a maximum of 10px.
Another issue is that if a new category is added to the data, you'll need to adjust everything again.
0 doesnt appear to me too
:/
Love your bite-sized chart tips! Thank You!
Glad you like them!
👍 . Is it possible to apply this same formatting in ‘small multiples’ option.?
Hi, Thank you very nice explanation but I have a question? What happen if I one of the categories did have a value for the period? I try to apply this technique but it still showing the category with the non value, how i can fix this, if I don't want the category there just the ones with values
I had the same issue. I got around it by wrapping an if statement around the base 0 measure to leave it null if my x axis value is not > 0. in my case it is for income so my base 0 measure is: Income Base 0 = IF([Income] > 0, 0)
Great
Thank you
I'm not able to see 0 added by base zero measure. Can you please help?
I hope you followed the steps in the video? Recheck you chart and change it to a matrix visual to ensure there measure produces the result
I'm having same problem also. Any help?
my percentage values appear inside the bar. I have tried everything but it does not budge. Can you please help? or anyone
I resolved this in PBI August 2024 version by following the similar procedure OP showed in the video utilizing the Dynamic Measure. In other words, when looking at the format of the Whole measure it displayed "0%;-0%;0%" which I replaced with " " to essentially make the measure empty and 100% no longer appeared on the bar 😊
@@guitngood7944 thank you
Looks like this one will need updating given Power BI as of February 2024 does not have Error Bars
=/
Disregard! I just found them (AI was telling me Error Bars are no longer available....)
@@PUPATRIL what can we do in this case ?