Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
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.
@D_PBI Have you played with the Contatenate/Don't Concatenate Labels?
@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.
@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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!