cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

How to write coding for color coding

Hi all,

 

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

dc.PNG

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")

dc.PNG1 = Red , 2 = Green

How to write coding for many range of color coding?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: How to write coding for color coding

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.

 

7.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: How to write coding for color coding

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.

 

7.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors