topic Re: Conditional formatting of a table by colour for whole row in DAX Commands and Tips

Conditional formatting of a table by colour for whole row

ompowerbi — Wed, 14 Sep 2022 16:14:12 GMT

Hi, I know how to conditional format a column, but how can one apply the background conditional formatting to one whole row. For instance, I would have this table:

Country	Sales	City
UK	105	London
France	92	Paris
UK	84	Manchester

I would want to make the UK rows blue and the French rows green for instance, almost conditional formating based upon values in the Country column, but I don't want to have to go into each column and do this, how can I do this immediately for a whole row? Thanks.

Re: Conditional formatting of a table by colour for whole row

PabloDeheza — Wed, 14 Sep 2022 18:29:30 GMT

Hi there!

It is still not possible to apply conditional formatting to row, therefore you have to apply it to each column of the table. It might help you speed up the process creating a measure like this (color can also be a Hex Code):

Country Matrix Conditional Formatting = SWITCH( SELECTEDVALUE( YourTable[Country] ), "France", "Green", "UK", "Blue", BLANK() )

You can vote for the feature on going to this link:

https://ideas.powerbi.com/ideas/idea/?ideaid=229a6a2b-f26c-4afd-b1af-8cf3cbc9810f

Let me know if that helps!