Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • Anonymous's avatar
    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.

     

    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.

     

  • Anonymous's avatar
    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