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! Get ahead of the game and start preparing now! Learn more
Hi all,
Using PBIRS Sept, 2021
I'm trying to add conditional format on a field so if values are less than 0, then background is Red and Font is white.
I could not find an option for less than (<)
I findly found suggestion to set regular background as red, font as white and then use conditional formatting for values >=0, so that is what I did.
That solved one problem, but created a new problem where I no longer have the alternate shaded rows in the Table Visual.
Is it possible to have my cake and eat it too on this one?
Thanks,
-w
Thanks Caitlyn,
Currently our Corp IT is only allowing PBIRS - Sept, 2021.
I heard rumor they will start allowing May, 2022 this Friday, 9/9.
Hopefully the new version will give us the lesser than "<" for conditional formatting
Hi @Anonymous ,
Have you tried to update to the latest version of PBIRS Desktop?
I can't rollback to 2021.9 but I tested on the current version and it is working.
Best Regards,
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 7 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |