Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
@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 ?
Hello @manojk_pbi ,
check this video https://youtu.be/SsN0lgNJX6A
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
107 | |
105 | |
90 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |