Forum Discussion
Memorable MemberHow to make format condition behave when Revenue increase is good and Expense increase is bad ?
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 ?
My PBI file
Paul
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 thisThis will give you the desired results:
Please accept this a solution if your question has been answered !!
Appreciate a Kudos 😀
2 Replies
- jaideepnema
Solution Sage
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 thisThis will give you the desired results:
Please accept this a solution if your question has been answered !!
Appreciate a Kudos 😀
admin11