Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Table Formatting Disrupts Alternate Shaded Rows in Table Visual

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

2 REPLIES 2
Anonymous
Not applicable

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

CFLess.PNG

Anonymous
Not applicable

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.

vcaitlynmstf_0-1662542847528.png

 

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.

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.