How to write coding for color coding

[Kamaizziati]

Hi all,

I have one table that need to show the different color coding based on a certain range value like picture below.

Currently I have done 2 color code only but I need four colour code. Below is the coding that I use now for show two color.

KPI = IF('Progress Update'[Var KPI Percent]<0,"1","2")

1 = Red , 2 = Green

How to write coding for many range of color coding?

[v-shex-msft · Accepted solution]

HI @Kamaizziati,

You can add a calculated column to check amount to switch the color image:

Sample:

KPI = 
var red="image url 1"
var yellow="image url 2"
var green="image url 3"
var blue="image url 4"
return
IF('Progress Update'[Var KPI Percent]>=-.6&&'Progress Update'[Var KPI Percent]<=-.2,red,
	IF('Progress Update'[Var KPI Percent]>-.2&&'Progress Update'[Var KPI Percent]<=0,yellow,
		if('Progress Update'[Var KPI Percent]>0&&'Progress Update'[Var KPI Percent]<=.02,green,
			if('Progress Update'[Var KPI Percent]>=.02,blue))))

Notice: you should setting the category to image url to enable these image url.

Regards,

Xiaoxin Sheng