Forum Discussion
Conditional formatting
Hi everyone I need help. I am new to PBI. I need to make a table and apply conditional formattig to the column "pig" (this is the average of data for date), like this: Green, if pig > curva Yello...
Please use
VAR _Pg = Selectedvalue(pg column)
VAR _minus = Selectedvalue(column)
VAR _Curva = Selectedvalue(Curva column)
Return
Switch(
True(),
_pig > _curva,"Green",
_pig > _minus && _pig < _curva,"Yellow"
_pig < _minus,"Red")
Thank so much PijushRoy for you time.
This is fine por individual values (previously achieved the same thing but in a different way), but like i say de column pig in the table is a average of de data for the date and the conditional formatting not apply for this.