How to make format condition behave when Revenue increase is good and Expense increase is bad ?

[admin11]

Hi All

I have a P&L summary table , the Vari % is compare YTD vs LYTD.

Logically for Rev YTD vs LYTD amount increase , Vari % i can set to text black ground = Green is correct.

As we all know Revenue and Expense are totally different. 

For Revenue increase is good.

But for Expense increase is bad.

Can some one share with me how to make Expense drop is good and Revenue drop is bad ?

https://www.dropbox.com/s/g4za059a0jc9vcd/PBT_V2021_339%20ask%20how%20to%20make%20expense%20blackgro...

My PBI file

Paul

[jaideepnema · Accepted solution]

Hi @admin11 ,

Create a measure like this

Color Code = SWITCH(SELECTEDVALUE(GL_Table_EXP[REV&COGS]),

"REV",IF([Vari %]*100>1,1,0),

"COGS",IF([Vari %]*100>0,1,0),

"EXP",IF([Vari %]*100<0,1,0),0)

and then on the table apply a conditional formatting on the background like this

This will give you the desired results:

Please accept this a solution if your question has been answered !!

Appreciate a Kudos 😀

[admin11]

@jaideepnema 

Your solution alway give me surprise , because it is so intelligent.

Thank You

Paul