topic Re: Conditional Formatting font text Amber in DAX Commands and Tips

Conditional Formatting font text Amber

Anonymous — Wed, 12 Aug 2020 08:52:06 GMT

Is there a way to change the font colour of a text column [BRAG STATUS] with the values "Green", "Amber" & "Red"

I'm able to use conditional formatting to get a value by field for the first values (see pic attached) but it doesn't pick up the amber colour:

I've even tried to use a switch function to change the HEX colours but I still cant quite get it

Conditional Colour Format = SWITCH(TRUE(),MAX(audit_results[BRAG STATUS])="Green",1,MAX(audit_results[BRAG STATUS])="Amber",2,MAX(audit_results[BRAG STATUS])="Red",3)

Any help on this would be great!

Thanks,

Re: Conditional Formatting font text Amber

amitchandak — Wed, 12 Aug 2020 10:24:19 GMT

Anonymous , As per this Amber is supported

https://blog.crossjoin.co.uk/2018/08/10/colour-names-supported-in-power-bi-conditional-formatting/

Hexcode you have to return with #. Hope you are using "Field" option and measure. Make sure you created a measure not column

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

color = switch ( true(), FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen", FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen", /// Add more conditions "red" )

Re: Conditional Formatting font text Amber

Anonymous — Wed, 12 Aug 2020 11:09:06 GMT

I have this measure but it cant load the data for the visual:

color =

switch ( true(),

FIRSTNONBLANK('audit_results'[BRAG STATUS],"NA") ="GREEN" && sum('audit_results'[BRAG STATUS]) ="GREEN","lightgreen",

FIRSTNONBLANK('audit_results'[BRAG STATUS],"NA") ="RED" && sum('audit_results'[BRAG STATUS]) = "RED","red",

)

The error is "MdxScript(Model) (22,70) Calculation error in measure 'audit_results'[color]: The function SUM cannot work with values of type String

Re: Conditional Formatting font text Amber

Anonymous — Sat, 15 Aug 2020 18:36:55 GMT

HI Anonymous ,

See if this helps.

https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/

Regards,

Harsh Nathani

Re: Conditional Formatting font text Amber

nandukrishnavs — Sun, 16 Aug 2020 05:16:59 GMT

Anonymous

BRAG STATUS	Column2
Red	1
Amber	2
Green	3
Red	4
Amber	5
Green	6
Red	2

DAX measure

Conditional_Colour_Format = VAR __status = CALCULATE ( FIRSTNONBLANK ( audit_results[BRAG STATUS], TRUE () ) ) VAR __color = SWITCH ( __status, "Green", "#4CAF50", "Amber", "#FFC107", "Red", "#f44336" ) RETURN __color