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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Pratz203
Helper I
Helper I

Coloring a risk matrix background

Hi All,

I have created a risk matrix using matrix visualization as shown below, where (I) shows impact and (P) shows probability.
The values are the count of risks

ValueLow (I)Medium(I)High(I)Very High(I)
Low (P)79432245
Medium(P)301132113
High(P)5539067
Very High(P)4211916

 

My expectation is to show it as below using the background color.

expectations.JPG






Is there any workaround to do this?

Would appreciate your response.
Thanks.


1 ACCEPTED SOLUTION

Hi @Pratz203 

 

look at this PBIX

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


View solution in original post

6 REPLIES 6
DR_GT
New Member

@Pratz203 hello,

The Table and Matrix controls have the "Conditional Formatting" option, you can color the background based on defined rules.

I leave the url with the information:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

Hi @Pratz203 

 

look at this PBIX

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Hi @Pratz203 

 

check this out.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-...

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Thanks for your response.
But my background formatting is independent on the value. The background color should be fixed. 

You can try also row header property.

 

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

You can use conditional formatting.

Refer the below thread :

https://community.powerbi.com/t5/Desktop/Matrix-Background-Color-Coding/m-p/891894

 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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