Showing results for 
Search instead for 
Did you mean: 
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

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors