Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
JL0101
Helper II
Helper II

How to show only the child values of a hierarchy with conditional background coloring

Hi,

 

Hi, I have created a hierarchy (powerbi built in hierachy creator) and put it into a matrix visual with condtional background color formating (using field value). I only want to show the colors for hierachyy X.X.X.X not X.X.X. As it does not make sense to roll up the values to the parent. however when I collapse from X.X.X.X it automatically rolls up the colour (see below). 

 

JL0101_0-1685456959707.png

 

M-key is a measure using 

M_Color = IF(ISINSCOPE('EI'[NRM1Level4_ETIM]),CALCULATE(SELECTEDVALUE('NRM1_Level_Colours'[ColorRgb]))) 
 
JL0101_0-1685457394447.png

 

 
JL0101_1-1685457231469.png

 

 
However this code is not working, any advice on this would be great.
0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors