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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
D_PBI
Post Patron
Post Patron

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
Super User
Super User

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


@ 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!:
The Definitive Guide to Power Query (M)

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.


@ 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!:
The Definitive Guide to Power Query (M)

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.


@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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