Use different formatting rules in one column of a table

[lucacebraak]

Hi everyone, 

I would like to ask for help. 

At the moment I am preparing a dashboard and used formatting tool by the table. Look below. 

 

In the difference column I used the formatting. But I would like to use a different formatting for 1.revenue/3.netto and 2.costs.

Now the minus values at costs seems bad, but in reality it is better dan last year. 

Can someone help me out? 

Thanks in advance. 

Kind regards, 

Luca 

[V-lianl-msft]

Try to create a measure like below and apply conditional formatting in difference column.

Measure 2 = 
SWITCH(TRUE(),
        MAX('Table'[type])="1.Recenue","red",
        MAX('Table'[type])="2.Cost","blue",
        MAX('Table'[type])="3.Netto","yellow")

[amitchandak · Accepted solution]

@lucacebraak , do you need to do want conditional formatting?

You can create a color measure and use that in conditional formatting using filed value option

examples

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4