Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
How do I Format ( Gray out /disable) the entire Table row based on a condition? The row and values must be visible.
Hint: https://community.powerbi.com/t5/Service/Color-row-based-on-date-condition/td-p/161638
Thanks
Alan Jacob
Solved! Go to Solution.
Hi @Anonymous ,
It seems that you want to condition format the row in the table visual.
I'm afraid that there is no option for us to set the row conditional format in power bi currently.
However, we could set the conditional formatting for the background color like below as a workaround.
You could set the background for Rolling Period, region and Total Units so that it will look like set the row conditional format.
If you still need any help, feel free to ask.
Best Regards,
Cherry
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Anonymous ,
It seems that you want to condition format the row in the table visual.
I'm afraid that there is no option for us to set the row conditional format in power bi currently.
However, we could set the conditional formatting for the background color like below as a workaround.
You could set the background for Rolling Period, region and Total Units so that it will look like set the row conditional format.
If you still need any help, feel free to ask.
Best Regards,
Cherry
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 42 | |
| 39 | |
| 23 | |
| 21 |
| User | Count |
|---|---|
| 144 | |
| 106 | |
| 63 | |
| 38 | |
| 31 |