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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors