Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I am creating a hierachy
Id level 1, level 2, level 3 level 4 level 5
1. A. B. C
2. A. D. E. F
3. M. N. O. P. Q
With the code below,
Measure = 
IF(
    ISINSCOPE('Table'[level 5]),
    IF(MAX('Table'[level 5]) = BLANK(),BLANK(),COUNT('Table'[Id])),
    IF(ISINSCOPE('Table'[level 4]),
    IF(MAX('Table'[level 4]) = BLANK(),BLANK(),COUNT('Table'[Id])),
    IF(ISINSCOPE('Table'[level 3]),
    IF(MAX('Table'[level 3]) = BLANK(),BLANK(),COUNT('Table'[Id])),
    IF(ISINSCOPE('Table'[level 2]),
    IF(MAX('Table'[level 2]) = BLANK(),BLANK(),COUNT('Table'[Id])),
    IF(ISINSCOPE('Table'[level 1]),
    IF(MAX('Table'[level 1]) = BLANK(),BLANK(),COUNT('Table'[Id]))
    ))))
    )I was able to remove nulls in the hierarchy. I want to know if there is a way to tell the user by color coding the font of level name when it reaches the last hierarchy level before null starts.
There probably is but... Would you care to give an example? Maybe a picture of what such a thing should look like, please?
In the picture below, C and its count, F and its count and Q and its count to be colored as red. So that people would know that is the last of hierarchy.
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | 
| User | Count | 
|---|---|
| 23 | |
| 12 | |
| 11 | |
| 10 | |
| 9 |