Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional formatting by hierarchy in a matrix

Hello all,   I have created a matrix where the value is a sum of [qty] which captures days effort.   I have added a conditional format to show when a resource is allocated over 1 in total and set...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    You can create a measure like below to format the colors. Then in conditional formatting window, select Format by Field value and Based on this Color Measure. You can use RGB color codes like "#00FF00" to replace the "Green" and "Red" color strings in the measure.

    Color Measure = 
VAR QTY = SUM('Table'[Qty])
RETURN
IF(NOT(ISINSCOPE('Table'[Level 2])),(IF(QTY<1,"Green","Red")))

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous 

 

You can create a measure like below to format the colors. Then in conditional formatting window, select Format by Field value and Based on this Color Measure. You can use RGB color codes like "#00FF00" to replace the "Green" and "Red" color strings in the measure.

Color Measure = 
VAR QTY = SUM('Table'[Qty])
RETURN
IF(NOT(ISINSCOPE('Table'[Level 2])),(IF(QTY<1,"Green","Red")))

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-jingzhang 

     

    Sorry for taking so long to test this. It works a treat! 🙂

     

    Thank you