Forum Discussion
Matrix Visual- remove a particular column from grand total
Hello All, I have a Matrix visual that has a few numberic column and one character column used as a class tag. The problem is for numeric column, it is ok to be summarized in grand total, but t...
nahid3152
Helper II
Helper IIHi,
You can use conditional formatting Background color for A="White" else "black"
AS like That
COLOR BG =
IF (HASONEVALUE('Table-1'[ClassCode])
,IF( FIRSTNONBLANK('Table-1'[ClassCode] , 0) = "A"
,"#FFFFFF"
,"Black"
)
,BLANK()
)
You can use conditional formatting Background color for A="White" else "black"
AS like That
COLOR BG =
IF (HASONEVALUE('Table-1'[ClassCode])
,IF( FIRSTNONBLANK('Table-1'[ClassCode] , 0) = "A"
,"#FFFFFF"
,"Black"
)
,BLANK()
)