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 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?