Color Formatting Row wise but few column are to be uncolored.

[FaisalImam]

Any measure to format background color  as shown below

metrics	expected	month1	month 2	month3
resolution	90%	45%	70%	30%
response	80%	90%	45%	25%

We need to format backgrounds only for month's cell - month1,month2 and month3 but row wise. Because conditions are different for every row.

Also first two column will remain colourless.

I tried with the inbuilt color formatting but it works for whole column and when doing measure,it works for whole row.

[Anonymous]

Hi, 

you need to write DAX expression for differnt values and use your expression for conditional formatting.

Here's an example: Conditional formatting by field value in Power BI - Power BI Docs

[amitchandak]

@FaisalImam , You can create color measures and check condition and color

Switch( True(),

max(Table[Month]) = "Jan", "White",

[Measure] <.8 , "red" ,

//add other condition 

)

Use this is conditional formatting using the field value option

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

[FaisalImam]

See this is the table. I want Feb SlA and MArch SLA backgroungd too change but based on key metrics. That is conditions are different for each row like  -Incident Resolution Backlog is 8% . So how to do it Row wise and only for some of the cells.

[v-easonf-msft · Accepted solution]

Hi, @FaisalImam 

Conditional formatting is applied to the column.

For each row on this column ,try to use  'Switch' statement to make additional conditional judgments.

Last Rate of each day =
SWITCH (
    SELECTEDVALUE ( 'Table1'[Key service value] ),
    'Incident resolution P1', IF ( [Feb SlA] > 0.08, "red" ),
    'Incident resolution P2', IF ( [Feb SlA] > 0.85, "green" ),
    'Incident resolution P3', IF ( [Feb SlA] > 0.90, "yellow" )
)

Best Regards,
Community Support Team _ Eason