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.
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
(Link: https://drive.google.com/open?id=1fMyuuCuvW3Ov1nU5R8qls7nJNZvrahLg)
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
Hi @Anonymous ,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |