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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.