cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SatyaSunitha1_
Helper I
Helper I

Row Level Conditional Formatting

Is there a way to do row level conditional formatting......created a matrix Table having fileds with category and Target value in row and Actual values for 5 months in column.

 

Each category has different Targets and need conditional formatting for Actual values.

4 REPLIES 4
ferryh
New Member

This would be very very useful

v-yulgu-msft
Microsoft
Microsoft

Hi @SatyaSunitha1_,

 

Under fields pane, right click the Actual values, select 'Conditional Formatting' option. Please review: Table & matrix conditional formatting improvement – blank formatting

 

But if you need to specify different colors for each category, in other words, set row color based on category type, there is no possible way to do so currently.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Is this still not a possibility? I need to color code a Matrix table by the row with multiple condition based colors.

So, just to confirm, there is no way right now to do a color a complete row based on the value of a cell in it ?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.