Forum Discussion

manojk_pbi's avatar
manojk_pbi
Helper V
3 years ago

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 ...
Need Help
Tahreem24's avatar
Tahreem24
Super User
3 years ago

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).

 

manojk_pbi's avatar
manojk_pbi
Helper V
3 years ago

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 ?