Forum Discussion
Conditional formatting by row in matrix
I want to color individual rows differently based on the row header in matrix (It's not alternating rows). Is that possible in Power BI? Also, I need to format cells based on their value. Eg: If ...
Hey,
Best way to format by row in a matrix is to create a new column in your data source which applies a numeric value to each header type that you would like to have highlighted. You can then use the conditional formatting setting to highlight based on this new column. For example if you want to highlight all of the rows that you labeled as "1" you can go to conditional formatting>background color>advanced controls>format by "Rules". Change your "Based on field" to the column you just created and put in rules such as If value "is" 1 then highlight....
Hope this helps.