Showing results for 
Search instead for 
Did you mean: 
SahilCompass Helper I
Helper I

Hierarchy Roll up Color

Hi members,

Need help with the following issue I am facing.

I am working with Hierarchies and looking for a way to display failed color at L1 hierarchy level when there is a failure at the lower level.

Attaching an example with PBIX file for reference


In this example in first level East is showing Red (as expected as it is failing), while West in showing Green.

But on drilling down at Level 4 there is one site in West that is failing.


Result I want to show (West).

Level 1: West - Red

Level 2: West - West D - Green, West H - Green, West W - Red

Level 3: West W LA - Red, all other West green

Level 4: As is


Please help


Re: Hierarchy Roll up Color

Hi @SahilCompass ,


The link of pbix file  you gave is invalid .Would you please inform us more detailed information( your sample data(by OneDrive for Business)) if possible? Then we will help you more correctly.


Please do mask sensitive data before uploading.


Thanks for your understanding and support.


Best Regards,

Dedmon Dai

Helpful resources

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

Top Solution Authors
Top Kudoed Authors