Matrix table conditional formatting by Row (not value)

[Sbezkoro]

Can I format Row background colors in Matrix table?

I need matrix table visuals like in the below example, where Product and Country are in ROW and Months in Column.
Sales in VALUES.

I have no problem to use conditional formatting for Sales, but I cannot make country column formatted accordingly as its value sits in Row of matrix table, but value.

Is it possible at all to do in PBI?

Thanks in advance!

[Anonymous · Accepted solution]

Hi @Sbezkoro ,

To my knowledge , It is not possible to perform row conditional formatting currently. You could register an idea for it or vote for the idea.

Unfortunately, you can only apply conditional formatting to values, totals, or both. It is also not possible to use color based on a calculation, you may apply the colors for the selected column, and base the formatting on the Field value of the column.

For more information, you can refer to：Use conditional formatting in Power BI 

Please see if the similar thread helps：Conditional format Row Text Matrix Table 

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Sbezkoro , You can create a color measure and use that. But you can use that only for values column not for rows/columns 

If(max(Table[Country]) = "PL", "Grey", "White")

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

[Sbezkoro]

No, this is the thing, that there is not issue how to format Value fields, but columns or rows.