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
RGallagher320
Frequent Visitor

Decomp trees visual

I am working on a decomp tree visual that just has specific levels with values. When I click on a level to expand the next level, the next level has a colored green bar and I cannot for the life of me figure out what that green bar length represents. I can't tell if it's based on the previous level to the left, a % of some total. I am totally baffled.

Has anyone used the decomp tree before and can explain how those green bars are represented?

Thank you.

Example below with the blurred out labels, but has the associated values.

 

 

 

Snipaste_2025-11-20_17-53-27.png
1 ACCEPTED SOLUTION
GeraldGEmerick
Solution Sage
Solution Sage

@RGallagher320 Are you talking about the green bars in under the Level 1, Level 2, etc? Those are just eye candy. The Green bars in the main area represent the number shown. Look at your last expansion. The 194M is the largest number and hence a full green bar. The 88M is about half that and so the green bar is about half. And so on. For the expansion just before that, the red bar represents the negative number -57M and the green bar is about a third of that number, 18M so the green bar is roughly a third of the red bar's length.

View solution in original post

5 REPLIES 5
v-sshirivolu
Community Support
Community Support

Hi @RGallagher320 ,

The green bars in the decomposition tree show the size of each category relative to the largest value at that level. So when you expand a node, the biggest category gets a full length bar, and the others are scaled proportionally, for example, if the largest value is 194 M, a category with 88 M will have about half the bar length. This comparison only happens within that level, not across the whole tree or previous levels. If there’s only one category, it naturally shows as a full bar. Knowing this makes it easier to see at a glance which categories are bigger or smaller. 

 

Hi @RGallagher320 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

 

Hi @RGallagher320 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

lbendlin
Super User
Super User

The bars show the size of the category relative to the maximum size across all exposed categories.  Since you only have one category at these levels they represent " 100 % "

GeraldGEmerick
Solution Sage
Solution Sage

@RGallagher320 Are you talking about the green bars in under the Level 1, Level 2, etc? Those are just eye candy. The Green bars in the main area represent the number shown. Look at your last expansion. The 194M is the largest number and hence a full green bar. The 88M is about half that and so the green bar is about half. And so on. For the expansion just before that, the red bar represents the negative number -57M and the green bar is about a third of that number, 18M so the green bar is roughly a third of the red bar's length.

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