Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
MH_Ger
Frequent Visitor

Lookin for bar chart that allows for subcategories

Hello everybody!

 

My goal is to visually represent every floor of a building and also show how much space each tenant occupies on each floor.

The two main requirements are the following:

 

1) Sort the bar columns from lowest floor to highest floor so that the order is identical to real life

2) Each bar shows how much of each floor is occupied by a specific tenant. Name of tenant/floor is immediately visible.

 

Using the inbuilt Power BI stacked bar chart, I can make something like this:

 

  PB1.png

 

 

 

 

 

 

 

 

The good thing is that this chart is sorted correctly: EG, 1. OG, 2.OG, 3.OG... (i.e., it correctly responds to the "Sort by column" command). Sadly, it can only show values (m²) within the bars instead of the name of the tenants.

 

An alternative I discovered from the store is this "Treemap Bar Chart by MAQ Software".

 

PB2.png

 

 

 

 

 

 

 

 

 

This chart meets my second requirement since it allows me to show the name of the tenants (this feature here is called "SubLegend"). Sadly the chart cannot be sorted, though.

 

Does anyone know of a visual element that can satisfy both requirements?

 

Best regards!

 

 

1 ACCEPTED SOLUTION

Thanks for the reply. I solved the problem by using the "Treemap Bar Chart by MAQ Software" chart and simply adding an alphabetical prefix to the name of the floor (e.g., "(a) EG"). This chart only ever sorts by alphabet.

View solution in original post

3 REPLIES 3
Mayank_Yavda
Resolver II
Resolver II

Hi @MH_Ger

 

Here is Stacked Bar with Custom Label and Sorting which will help you  to get tenant name as data label and sort the visual.

Stacked Bar Chart with Custom label and Sorting, PBIVizEdit.comStacked Bar Chart with Custom label and Sorting, PBIVizEdit.comStacked Bar Chart with Custom label and Sorting, PBIVizEdit.comStacked Bar Chart with Custom label and Sorting, PBIVizEdit.com

 

 

 

 

 

 

 

 

Download link for the custom visual file in this page,

https://pbivizedit.com/gallery/stacked-bar-chart-with-custom-data-label-and-sorting 

 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

  • anyone, irrespective of technical skills, can create their own visuals
  • 15 minutes to create a visual from scratch
  • opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problem/errors.
You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

Thanks,
Team PBIVizEdit

v-jingzhang
Community Support
Community Support

Hi @MH_Ger 

 

I didn't find a visual that can satisfy both requirements. As a workaround, you could use the built-in stacked bar chart and turn on Legend option in it. This can show you the names of the tenants.  

vjingzhang_1-1645763044141.png

 

You could raise up an idea at Ideas (powerbi.com) to let other people vote for it. Here is one similar idea you can vote up: Microsoft Idea - Stacked Bar Chart Choose Data Label

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Thanks for the reply. I solved the problem by using the "Treemap Bar Chart by MAQ Software" chart and simply adding an alphabetical prefix to the name of the floor (e.g., "(a) EG"). This chart only ever sorts by alphabet.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.