Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
manojk_pbi
Helper III
Helper III

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

 

 

manojk_pbi_0-1690784849399.png

eg: Sample data below

BugIDSeverityImpactProject
B112Proj1
B222Proj1
B314Proj1
B431Proj1
B534Proj1
B642Proj1
B744Proj2
B834Proj2
B924Proj2

 

Expected Output for Proj 1 Selection: 

manojk_pbi_1-1690785668242.png

 

 

3 REPLIES 3
Tahreem24
Super User
Super User

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

Tahreem24_1-1690786726555.png

 

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

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
Super User
Super User

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.