Forum Discussion
Bar Graph Category
Hi
When i am trying to go to next level in the bar graph, category is not showing properly in the latest version of Powerbi.Can anyone please help me with this.
Level 1
Level 2
Hi Md_asgar_786
I didn't quite understand the question, so I simply recorded screens of the graph creation and formatting.
Here's the link to the video:
https://drive.google.com/file/d/18xMHioTCEyRz_SfY33_g7_zdcFnK9qLY/view?usp=sharing
Hope it helpsIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
5 Replies
- Ritaf1983Super User
Hi Md_asgar_786
This happens because there isn't enough space for the string in the hierarchy, which is longer than the height of the bars at the level below.You can see in my example that some of the names are shown properly and in the cases of fewer bars in the next hierarchies it looks like in your image :
To deal with this issue you can resize the space between the bars :
My recomendation
In such cases, since we don't have many design options here, I recommend using a matrix with conditional formatting. You'll get a much more organized and aesthetically pleasing resultThe pbix with the examples is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- Md_asgar_786New Member
Thanks for sharing the solution, but my requirement is same like you have done in the below visual:
Level 1:How to reduce the length of the Bar, then we show both category as well as sub-category.
Level 2:
In the 2nd level visual which you have created you are showing categoryName as well as firstName as per your pbix file. that how you have achieved and as well as in Y axis you are showing category name also for a group that also i would like to undertand how you have done it.
- Ritaf1983Super User
Hi Md_asgar_786
I didn't quite understand the question, so I simply recorded screens of the graph creation and formatting.
Here's the link to the video:
https://drive.google.com/file/d/18xMHioTCEyRz_SfY33_g7_zdcFnK9qLY/view?usp=sharing
Hope it helpsIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- Md_asgar_786New Member
Hi Ritaf1983
Thanks for sending the video for Formatting, It really helped me. Just one question, it's not related to Powerbi. Which software you are using for screen recording. Video is very good.