topic Re: Table Formatting Disrupts Alternate Shaded Rows in Table Visual in Report Server

Table Formatting Disrupts Alternate Shaded Rows in Table Visual

Anonymous — Tue, 06 Sep 2022 21:34:49 GMT

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

Re: Table Formatting Disrupts Alternate Shaded Rows in Table Visual

Anonymous — Wed, 07 Sep 2022 09:28:51 GMT

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.

Re: Table Formatting Disrupts Alternate Shaded Rows in Table Visual

Anonymous — Wed, 07 Sep 2022 17:22:38 GMT

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