Conditional formatting by row

[J_S_A]

Hi all,

I'm wondering if anyone could help me solving this.

I have a visual table in Power BI that looks like this:

All columns have been calculated, based on the main table.

What I need to do is to apply a conditional formatting by row. So, for example, for row "CR Medium 20 - 60 MD" I need the value for "Average of Dev_Created_FuncSpec" (which is 38.58) to be red, and the lowest one to be green.

In other words, I need to compare the values by row and highlight the highest ones.

See example of what I mean in excel:

Is this possible?
Thanks in advance!

[fahadqadir3]

Hi, you need to create a color measure for each measure. Review the attached screenshot and power bi file.

RowMax = 
MAX( [Measure A], MAX( [Measure B], [Measure C] ) )

Case 2 when sales is less than other measures, color turns blue.

ColorMeasureA = 
IF( [Measure A] = [RowMax], "#FF0000", "#0000FF" )

ColorMeasureB = 
IF( [Measure B] = [RowMax], "#FF0000", "#0000FF" )

Then apply conditional formatting, field value to each measure.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[J_S_A]

Hi @fahadqadir3 ,
I'm trying to use the "RowMax" measure but it doesn't work in my case. I can only add 3 variables, but I have 5 variables (see below):

I get the variables from the third one afterwards underlied in the measure, so there should be an error/limitation:

Also, I would like to know what do you do with the "RowMax" and the colors measures. I don't see they are added in the filters nor the table.

Thanks!

[J_S_A]

hI @fahadqadir3 

I have created this measure to obtain the Max Deviation in each row:

MaxDeviation =

VAR ValuesTable = {

    [Average_Created_FuncSpec],  

    [Average_FuncSpec_Handover],  

    [Average_Handover_Delivery],  

    [Average_UAT_Deploy],  

    [Average_Deploy_Completed]

}

VAR MaxValue = MAXX(ValuesTable, [Value])

RETURN MaxValue

Then, i have created this measure for the color:

Color_Created_FuncSpec =

IF( [Average_Created_FuncSpec] = [MaxDeviation], "#FF0000", "#0000FF" )

But nothing changes.
Could you please help me?

[J_S_A]

Hi @fahadqadir3 , @andrewsommer 
Could anyone help me with the solution?
Thanks

[andrewsommer]

To start it looks like you are using implicit measures in your power bi table instead of explicit measures.  If you make explicit measures for those fields and then put them in the values field of a matrix visual.  In the formatting for the matric go to Values > Options > Switch values to rows.

Then you should be able to click on each measure in the Values box of your visualization to add conditional formatting to that field. 

Please mark this post as solution if it helps you. Appreciate Kudos.

[J_S_A]

Hi.
Thanks for advising to turn the measures into explicit ones. I've done it, but unfortunately I don't want the table to look like the matrix you have proposed. I want it to look like as I have attached.
Thanks anyway!