topic Conditional Format Value Based On String Not Numbers in DAX Commands and Tips

Conditional Format Value Based On String Not Numbers

Anonymous — Fri, 13 May 2022 10:34:46 GMT

I have The Following Table

Status	Campaign type
Completed	A
Completed	A
Completed	B
Completed	R
Completed	D
Completed	A
Cancelled	F
Cancelled	GS
Cancelled	GS
Cancelled	W
Cancelled	E
Cancelled	T
Cancelled	U
Cancelled	W
Cancelled	HG
Cancelled	SF
Cancelled	AS
Cancelled	YF
Paused	A
Paused	N
Paused	N
Paused	J
Running	L

So i want to condional formal the campaign type based on staus so like if completed the campaign type should be green, if canceled red, if paused yellow, if running blue

Re: Conditional Format Value Based On String Not Numbers

OwenAuger — Fri, 13 May 2022 12:00:26 GMT

Hi Anonymous

For this type of colouring rule, you would need to create a measure that depends on the value of Status, and returns the colour as a text value.

See here for details on the types of text values that are acceptable for defining colours.

The conditional formatting would then use Format style = "Field value" and be based on the measure.

Here is a simple example I created in a table visual:

Regards,

Owen