Conditional Format on a Row (Table)

[Anonymous]

Morning

Greetings from Scotland

I have a measure which is True for a when a Task status being in the status Complete

I use the measure as a conditional format in a table to turn it (the row/cell elements) green as the task is complete, I basically want to show all fields as green See Fig 1

The last entry – the task is not complete and so its stays as it is.

My issue is that I had to set this measure on each cell element individually.

If I had 20x columns; that’s 20x columns  where I had to cerate the conditional format

Is there no way to say for a row that if the value is complete, then all cell elements are complete?

i.e the who;e row turns green? 

If you look at Fig 2 – just for discussion; for each column (5x columns) I had  to go in and set the Conditional Format 5X Times.

If I have 20x columns – that is a pain.

Am I making sense?

Fig 1

Fig 2 Excel Mock-up

Comments welcome

Jimmy

[Anonymous]

@Anonymous 

Thanks for the reply. Indeed it seems crazy that thos does not exist.

[Anonymous · Accepted solution]

Hi @Anonymous 

Unfortunately that power bi doesn't support this feature currently, conditional Formatting works for Fields/Columns and not for Rows/Records. So you will have to apply conditional formatting for each Field/Column separately.

Now a days, many Power BI users have voted for an idea that Conditional Formatting should be made available to highlight entire row in the Table/Matrix Visual, but it is yet to implemented.

Maybe you can vote for it in this link:

Microsoft Idea

Best Regards

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