Forum Discussion
Matrix with background color
Hi Friends,
I would like to create a matrix with below data and background colors. In each cell it should represnt corresponding bug counts, if bugs are not present in the specifc category still matrix should show the colored background with no data. How to achieve this ?
Any help or suggestions are much appreceiated
eg: Sample data below
| BugID | Severity | Impact | Project |
| B1 | 1 | 2 | Proj1 |
| B2 | 2 | 2 | Proj1 |
| B3 | 1 | 4 | Proj1 |
| B4 | 3 | 1 | Proj1 |
| B5 | 3 | 4 | Proj1 |
| B6 | 4 | 2 | Proj1 |
| B7 | 4 | 4 | Proj2 |
| B8 | 3 | 4 | Proj2 |
| B9 | 2 | 4 | Proj2 |
Expected Output for Proj 1 Selection:
3 Replies
Hello manojk_pbi ,
check this video https://youtu.be/SsN0lgNJX6A
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
manojk_pbi You need to create a measure then apply this measure to background color fx setting.
BG color = SWITCH(TRUE(),
SUM(Severity) * SUM(Impact) >=5 && SUM(Severity) * SUM(Impact) <10, "Red",
SUM(Severity) * SUM(Impact) < 5, "Yellow",
"Green")
Then apply this measure as per below screen shot, In Background option choose the measure name (BG Color).
Thanks for your quick response. this will help in getting the background colors. How could we retain the matrix intact with all rows & columns with color irrespective of selections ?
