How to Conditionally format text in a Card in Power BI

Question

&nbsp;I have a Card in a power BI Dashboard that that displays roughly 6 unique text attributes depending on the input. How do I add a separate color to each attribute, for example if the card displays "apple" I want that text to be red.

evandrocunico · Answer

it´s a color in hexadecimal.see the colorshttps://www.w3schools.com/colors/colors_picker.asp&nbsp;

evandrocunico · Answer

hi&nbsp;Anonymous&nbsp;&nbsp;card_color = if(fieldvalue = "APPLE";"#F0F0F0";"#FFE4B5")&nbsp;CARD - format - data label, conditional formatting - field value - select card_color&nbsp;regards.

anonymous · Answer

evandrocunico&nbsp;Thanks for the reply, I'm farely new to Power BI but what does&nbsp;#F0F0F0";"#FFE4B5 mean?

anonymous · Answer

evandrocunico&nbsp;I know this dosen't work but I think this is close to what I want. How could I fix this to get each text value assigned to a color.&nbsp;&nbsp;Test Color = VAR Color = SELECTEDVALUE(Table[Color]) Return SWITCH(TRUE(), Color = "#FF0000", "Apple" )&nbsp;Then Conditional format by field Value

evandrocunico · Answer

Your first question&nbsp;for example if the card displays "apple" I want that text to be red&nbsp;Measure:&nbsp;COLOR = iF(SELECTEDVALUE(Tabela1[FRUIT])=BLANK(); "#f2f2f2";iF(SELECTEDVALUE(Tabela1[FRUIT])="Apple";"#ff0000";iF(SELECTEDVALUE(Tabela1[FRUIT])="Avocato";"#55ff22";"#ff7722")))&nbsp;CARD - Data label - color - conditional format - field value by COLOR&nbsp;&nbsp;

Forum Discussion

How to Conditionally format text in a Card in Power BI

9 Replies

Related content

Conditionally Format a measure in a calculation group

How to conditionally format native waterfall chart?

Conditionally Format X-Axis

Conditionally Format Area Chart

Conditionally format bar chart based on another field value