Forum Discussion

bk123's avatar
bk123
Regular Visitor
8 years ago

Heatmap just to compare the rows

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

5 Replies

    • bk123's avatar
      bk123
      Regular Visitor

      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's avatar
        Astro
        Icon for Helper I rankHelper I

        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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello,

     

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

     

    Thank you in advance