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
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.
Do you need help in Spanish? Check out our new Spanish community section.
Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.