Forum Discussion
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 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)
1 Reply
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
