conditional formatting in matrix data

Question

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"

,"#C8F4FF"

,"white"

)

,BLANK()

)

if we expand the matrix the colour is moving away, any way to keep formatting always?

amitchandak · Answer

sanjanarama , Just try this version
&nbsp;
,IF( max(Sheet2[hirachy]) = "Global","#C8F4FF","white")

sanjanarama · Answer

amitchandak&nbsp;tried this, still the same

amitchandak · Answer

sanjanarama ,Can you share a sample pbix after removing sensitive data.

sanjanarama · Answer

amitchandak&nbsp;https://drive.google.com/file/d/1N8_8G0EGT0TLwvi1FeAJgD0AQ-WUK_gC/view?usp=sharing&nbsp;&nbsp;

Forum Discussion