Conditional formatting

[SoledadMancilla]

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:

[SoledadMancilla]

Hi @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.

[PijushRoy]

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")

[SoledadMancilla]

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.

[PijushRoy]

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
Pijush