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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
D_PBI
Post Partisan
Post Partisan

Is there a horizontal (or vertical) bar-graph visual that expands like the matrix visual?

Hi,
I would like to know if there is a horizontal (or vertical) bar-graph visual that show bars at the top tier, but also has the ability to be expanded invidually so the next tier is expanded out?
For example, see the screenshot below of the matrix visual. It has two tiers - Year then Month. I'm looking for a bar-graph visual that has the ability to have a bar for the top tier and then can expand individually (like how I've expanded individually for the Year 2020-21) to show the next tier down.

D_PBI_0-1708614234033.png

 

I ask this as I currently have both tiers expanded in a bar-graph using the 'drill to next level' function, but the names of the two tiers have become too squashed it's unreadable.
Thanks.

5 REPLIES 5
Greg_Deckler
Community Champion
Community Champion

@D_PBI Have you played with the Contatenate/Don't Concatenate Labels?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler  - I hadn't but have now. It still looks cramped. Getting away from the squashed looking tier names, it would be a much cleaner approach if the report consumer (who may get confused with the drill modes) could expand (and close) an individual tier rather than needing to navigate the drill modes to expand down (and back up) into the hierarchy.

Is there a bar-graph that has this capability?
Thanks.

@D_PBI Well, sort of, I would try data bars conditional formatting. I think that will work pretty well in a matrix visual. I will also look for custom visuals that might do the trick.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler I hadn't thought of data bars. I'm looking into them now. One point to add, I would need the bars to be stacked. In a crude attempt to demonstrate...
Tier 1 (when expanded)
      Tier 2   [Stacked Legend 1  ||  Stacked Legend 2  ||  Stacked Legend 3]
      Tier 2   [Stacked Legend 1  ||  Stacked Legend 2  ||  Stacked Legend 3]
      Tier 2   [Stacked Legend 1  ||  Stacked Legend 2  ||  Stacked Legend 3]
Tier 1  [Stacked Legend 1  ||  Stacked Legend 2  ||  Stacked Legend 3]|  
Tier 1  [Stacked Legend 1  ||  Stacked Legend 2  ||  Stacked Legend 3]
and so on...

@D_PBI There are lots of options in AppSource if you search "bar chart" or "stacked chart" (Ultimate Stacked Chart) for example. Whether any of them do exactly what you want, I don't know, you'll have to experiement with them.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors