How to plot life span of products

[Biju]

I have the following data,I need to plote it using the below criteria.

Compare the average life of the pipe with the data and mark it as “Red” to show that

1)If the average life of the material is 50% lower than the lifespan mentioned above – Mark Green

2)If the average life of the material is between 51% - 90% lower than the lifespan mentioned above – Mark Yellow

3)If the average life of the material is > 90% lower than the lifespan mentioned above – Mark Red

Material	Average of Age	Min Life	Max Life
CIP	69.28	50	75
COP	56	35	60
GIP	55	45	60
D&W	53.58	60	100

Can any one help me to solve this problem?

Thanks in advance.

[Abduvali]

Hi @Biju,

See video below on how to use conditional formatting in Power BI on my Youtube channel:

• Conditional Formatting in Power BI

Regards

Abduvali

[Biju]

Hi Abuvali,

I couldnot apply conitional formatting in this scenario.

Thank you.