How to color a field in a row inside a table in PowerBI?

[jtj]

I want to color each field with the biggest value green within each row. How can I do this? Without doing it manuelly. I think it has something to do with Conditional formatting?

[v-nuoc-msft · Accepted solution]

Hi @jtj 

@Uzi2019 @KeyurPatel14 Thank you very much for your prompt reply. Please allow me to share other methods here.

If your source data is in the following format, perform the unpivot operation.

Select Transform data to enter Power Query.

You'll get:

Create a measure.

Measure = 
VAR RowMax = CALCULATE(MAX('Table'[Value]), FILTER(ALL('Table'), 'Table'[Category] = MAX('Table'[Category])))
RETURN
IF(SELECTEDVALUE('Table'[Value]) = RowMax, "GREEN", "WRITE")

Create a matrix.

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jtj]

It seems like the awnser is to make a matrix instead of a table.

[Uzi2019]

hi @jtj 

Please check the below video for better understanding.

https://www.youtube.com/watch?v=m0h3Ghl6mgY

https://www.youtube.com/watch?v=wTRrskQzAHk

https://www.youtube.com/watch?v=FSTiPm5tY8A

I hope above videos would help you to understand the conditional formatting setting for Matrix visual.

[KeyurPatel14]

Hello @jtj ,
Hope you are doing well.

Could you please share the sample file?