Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 11 | |
| 9 | |
| 6 | |
| 6 |