Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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:
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.
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:
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.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |