Need help with Power BI Conditional formatting for selected Rows

[Anonymous]

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 datasetsOutput

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)

[amitchandak]

@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