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
fahadqadir3's avatar
fahadqadir3
Solution Supplier
1 year ago

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