Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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)
This will give you the desired results:
Please accept this a solution if your question has been answered !!
Appreciate a Kudos 😀
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)
This will give you the desired results:
Please accept this a solution if your question has been answered !!
Appreciate a Kudos 😀
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |