Forum Discussion
Solved
Conditional Formatting on Tables
Hi, I'm not sure if a recent update has changed this but it's become more difficult to create conditional formatting on tables based on a minus value. I'm trying to make the background of t...
Hey mwimberger ,
I think I solved it, basically it need a text field to reference against. It was weird but once I dropped in the Project field (Text) into the table, all of the conditional formatting came to life. Strange and never experienced it before!
Thanks for your input though, really appreciate it.
Ben
Hi both mwimberger v-juanli-msft ,
I've just done another update and mine is still completely different from both of yours, I don't even have the number field that v-juanli-msft has.
Do you think it's worth doing a full uninstall and reinstall? Can't understand why it would be so different.
Thanks for your continued help!
Hi
So I doubt a reinstall will do anything. I would check the field you are trying to get the formatting for isn’t set to mixed text and numbers or maybe text . It may trip it up in this case.
You can set this in the modelling tab or in the Power Query step.
Cheers
Manfred
So I doubt a reinstall will do anything. I would check the field you are trying to get the formatting for isn’t set to mixed text and numbers or maybe text . It may trip it up in this case.
You can set this in the modelling tab or in the Power Query step.
Cheers
Manfred