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!