Forum Discussion

sanjanarama's avatar
sanjanarama
Icon for Resolver I rankResolver I
4 years ago

conditional formatting in matrix data

I have created measure to add conditional formatting for values in matrix COLOR GLOBAL CUSTOMER ROW = IF (HASONEVALUE( Sheet2[hirachy] ) ,IF( FIRSTNONBLANK(Sheet2[hirachy] , 0) = "Global" ,"#C8...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

sanjanarama , Just try this version

 

,IF( max(Sheet2[hirachy]) = "Global"
,"#C8F4FF"
,"white"
)