Matrix with background color

[manojk_pbi]

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: 

[Tahreem24]

@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]

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 ?

[Idrissshatila]

Hello @manojk_pbi ,

check this video https://youtu.be/SsN0lgNJX6A

https://youtu.be/3AmXqEJ9TmM

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin