Forum Discussion
Red Green Status
Hi everybody,
for my PowerBI reporting I need support.
Background:
The department makes a weekly tour of the building to identify deficiencies. Each level (e.g. First floor) is evaluated (green eq everything ok, red eq certain points not ok). The tour and the corresponding levels are recorded in the background. It can happen that the same building is checked twice in one month.
Current situation:
I have used conditional formatting:
| Status | number | conditional formatting for background |
| Red | 2 | If number eq 2, red |
| Green | 1 | If number eq 1, green |
| Grey (not checked) | 0 | If number eq 0, grey |
Now if I have a second round a month, the reporting is wrong because I used the sum-functions.
| Level | First round | second round | current result | Expected result |
| 1. floor | 0 (grey) | 0 (grey) | 0 | 0 |
| 2.floor | 0 (grey) | 1 (green) | 1 | 1 |
| 3.floor | 0 (grey) | 2 (red) | 2 | 2 |
| 4.floor | 1 (green) | 0 (grey) | 1 | 1 |
| 5.floor | 1 (green) | 1 (green) | 2 | 1 |
| 6. floor | 1 (green) | 2 (red) | 3 | 2 |
| 7. floor | 2 (red) | 1 (green) | 3 | 1 |
| Basement | 2 (red) | 0 (grey) | 2 | 2 |
| 8. floor | 2 (red) | 2 (red) | 4 | 2 |
Any ideas to find the correct logic?
Thanks!
3 Replies
But how did you get the expected result? How did you calculated it to place on your example?
Most of them seems to be the highest value however for floor 7 you have the second round value.
Can you explain your tough behind the example you gave.
