Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi All!
I have a matrix with 4 levels. There are possible values on each one of those hierarchy levels. I need to display a flag on the top most hierarchy level (level 1) if there is a value that exists on any of the four levels. Does anyone have any tips on how to accomplish that?
Thank you!
Could you show a screenshot of what the result looks like now?
Proud to be a Super User! | |
Hello,
You can consider using a mix of Variables and IF statements. Consider:
MEASURE =
VAR _Level1 =
IF ( ISBLANK ( 'Table'[Level1] ), 0, 1 ) //You can tweak the "ISBLANK" statement depending on how you are determining value for the level
VAR _Level2 =
IF ( ISBLANK ( 'Table'[Level2] ), 0, 1 )
VAR _Level3 =
IF ( ISBLANK ( 'Table'[Level3] ), 0, 1 )
VAR _Level4 =
IF ( ISBLANK ( 'Table'[Level4] ), 0, 1 )
RETURN
IF ( ( _Level1 + _Level2 + _Level3 + _Level4 ) > 0, "Flag", "" )
Proud to be a Super User! | |
Thanks for your reply!
I have tried something similar, but here it is with you structure. It still only displays the flag when the measure exists on that specific level
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |