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
Yellow, if pig > (-) and < curva
Red, if pig < (-)
And use this conditional formatting for a bar chart too.
This are de date:
4 Replies
Hi SoledadMancilla
Please create a measure
Color = Switch(
True(),pig > curva,"Green",
pig > (-) && pig < curva,"Yellow"
pig < (-),"Red")
Use the proper field in above measure.
Go to conditional formating option, and use the measure as Field value
Check the article - https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
follow Section - Color based on a calculation
Thanks
PijushHi PijushRoy
But with that formula just i can use measures and my values are not a measure.
It won't let me choose the columns i need.
Please use
VAR _Pg = Selectedvalue(pg column)VAR _minus = Selectedvalue(column)
VAR _Curva = Selectedvalue(Curva column)
ReturnSwitch(
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.
