Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Is there any way to apply Conditional Formatting on Text Columns in Power BI Matrix Visuals

I just wanted to apply Conditional Formatting on Text Columns in Power BI Matrix Visuals [Blank Cells with Red Background and NON Blank Cells with Green Background] Structure below -- AppName Property1 Property2 App1 ABC App2 DEF

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    You will need a measure like: Measure 4 = VAR __text = MAX([Column1]) RETURN IF(__text = "",0,1) Then you can use that with your conditional formatting. See attached. Page 8, Table 12