Forum Discussion

J_S_A's avatar
J_S_A
Helper I
1 year ago

Conditional formatting by row

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 n...
Need Help
J_S_A's avatar
J_S_A
Helper I
1 year ago

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's avatar
J_S_A
Helper I
1 year ago

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?