Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Biju
Helper I
Helper I

How to plot life span of products

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

MaterialAverage of AgeMin LifeMax Life
CIP69.285075
COP563560
GIP554560
D&W53.5860100

 

Can any one help me to solve this problem?

 

Thanks in advance.

2 REPLIES 2
Abduvali
Skilled Sharer
Skilled Sharer

Hi @Biju,

 

 

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

 

Regards

Abduvali

Hi Abuvali,

 

I couldnot apply conitional formatting in this scenario.

 

Thank you.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.