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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Conditional Formatting for Data in Different Rows with Different Targets

Hi All,

 

I'm looking to use conditional formatting for a table with each row having a different target.

 

Say for example:

 

ProcessTargetJan Feb Mar
Process 140402355
Process 235533435
Process 320181920
Process 45156
Process 515121414
Process 615141515
Process 724242424
Process 834383333
Process 950505251
Process 1053555949

 

So I need to color code the values for Jan, Feb & March for based on a certain percentage of the invidual target

 

The conditions are:

 

1) Upto 75% of the Individual Target - Red Color

2) 76% - 99% of the Individual Target - Amber Color

3) Above 99% of the Individual Target - Green Color

 

Your assistance is highly appreciated

 

Cheers 🙂

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi Vik,

Check care out these images:

 

MeasureMeasureConditional Format PathConditional Format PathCond. Format ConfigurationCond. Format Configuration

 

Then, create same measures but for Feb and Mar and configure its conditional formatting because your data model isn't normalized.

 

Tell us if works for you.

 

 

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi Vik,

Check care out these images:

 

MeasureMeasureConditional Format PathConditional Format PathCond. Format ConfigurationCond. Format Configuration

 

Then, create same measures but for Feb and Mar and configure its conditional formatting because your data model isn't normalized.

 

Tell us if works for you.

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.