Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hello,
I also appreciate that this post is a little old - was there a solution found to the problem however?
Thank you in advance
Instead, you may try Conditional table formatting in Power BI Desktop.
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |