Matrix with background color

manojk_pbi · ‎07-30-2023

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 · ‎07-30-2023

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

manojk_pbi · ‎07-31-2023

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 ?