Heatmap just to compare the rows

[bk123]

Hello,

i´m searching for a heatmap solution that compares just the rows of a table. Problem is now, that the standard heatmap n PowerBI compares all the numbers in a table, but I need a solution that compares just the different numbers in a single row.

Solution must be that the highest number in a row is green, and in the next row there ia a green one again.

The problem now is, that I have green on the highest number in the table, and all lower numbers gets more red, but that is not what I want or need.

Hope u understand what I need, and maybe you can help me with that.

Thanks in advance

[Anonymous]

Hello,

I also appreciate that this post is a little old - was there a solution found to the problem however?

Thank you in advance

[v-chuncz-msft]

@bk123,

Instead, you may try Conditional table formatting in Power BI Desktop.

[bk123]

Thanks, but this is exactly what i tried. Problem here is that the formatting, formts all informations in the table, not just the information in a row.

In Excel it´s easy to do it with customized formatting, but here in PowerBi it seems not to be working.

What I want is

Name 1   2  5  6  1  2

Name 2   3  5  8  7  1

Name 3   0  2  4  9  4 

What the customizes formatting is doing

Name 1   2  5  6  1  2

Name 2   3  5  8  7  1

Name 3   0  2  4  9  4

it formats all the numbers, by comparing them, and makes the highest one dark green, and the lowest one dark red.

And I need the highest number green in a row, and the same green in the next row for the highest number, not important if the number in row 1 differs to the number in row2.

[Astro]

Hi bk123,

I appreciate this post is old now but did you ever find a solution to this? I'm trying to achieve the same thing.

Many thanks

Nick

[bk123]

Hey Nick,

unfortunately I´ve nerver found a solution for this. I use the heatmap as it is.

let me know, if u find a better solution.

Greetings