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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Need help with Power BI Conditional formatting for selected Rows

Hello Community,

 

Need help with Power BI Conditional formatting for selected Rows. I've added the Col A in the dataset for making the DAX easy. I've mentioned the sample datasets template and the final output snapshot. Any help much appreciated...

 

P&L sample datasetsP&L sample datasetsOutputOutput

 

 

User Cases


1.Depending on the Format column, like to change the data format to % which has PERCENT value under FORMAT (As shown in Excel output)

2.Depending on the Format column, like to make The entire row Bold which has Bold value under FORMAT (As shown in Excel output)

3.Depending on the Format column, like to make show dark line on top and bottom cell which has Double Bold value under FORMAT (As shown in Excel output)

 

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , As of not in Matrix Conditional formatting is not supported for columns in row/column (pivot).

 

You can do that in the table for all columns, but not in the matrix. Matrix only values you can color

 

You can create a color measure and use that in conditional formatting with field value option

 

Switch(true() ,

max(Table[Heading]) = "Normal", "Yellow" ,

//Add other

)

 

 

refer

PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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