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
esanchezc
New Member

conditional formatting Table or Matrix

Good
I would like to know if this table elaborated in Excel is possible to realize it in PowerBI?

 

 

where the color considerations is based on the following conditions

 

 

In Power BI I have this table

 

But I can not do what is indicated, any suggestions? Thank you.

 

 

 

 

2 REPLIES 2
v-huizhn-msft
Employee
Employee

Hi @esanchezc,

 

As @MattAllington posted, we are unable to set the color like yours. With conditional formatting for tables, we only can specify customized cell background colors based on cell values, including using gradient colors. You can right click value level->conditional formatting(highlighted in yellow background) like the following screenshot. 

 

Capture1.PNG

You can vote it and view the update in this link. Thanks a lot.

Best Regards,
Angelia

You can't do it like Excel, but both the matrix and table both have conditional formatting - it is just it is not where you would expect to find it.  You need to go to the fields tab on teh right (not the formatting tab), click the drop down arrow next to the value item and you will see it.  You can have 2 or 3 colour variation - that it is for now.



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

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.