Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi PowerBI Gurus,
I have created below measure to show an arrow based on value go up and down.
Arrow works fine. But I need to make it green when it pointing up and make it red when it is pointing down.
my measures are as below
Measure 1(used in final arrow measure)
-------------------------------------------------------------------
Minutes :=
CALCULATE(
SUM(
Tabel1[CallMinute]
)
)
----------------------------------------------------------------------
Measure2(used in final arrow measure)
-------------------------------------------------------
Forcast :=
CALCULATE(
SUM( Table1[Target]
)
)
-------------------------------------------------------------------------------------------
Finial Arrow Measure
===================================================
ArrowUpDown :=
VAR Arrow = SWITCH(TRUE( ),
[Forcast] < 0, UNICHAR(129095),
[Minutes] > 0, UNICHAR(129093),
BLANK( )
)
RETURN
IF(
ISBLANK(Arrow), " ", Arrow
)
====================================================
i used this measure in a tabel column.
I haev tried formating this measure using other columns in the tabel like Tabel1[CallMinute] and Table1[Target].
Your help is much appriciated.
Regards
Amal Eranda
Solved! Go to Solution.
Hi,
I have created the below pbix.
Check if this is what you need.
https://1drv.ms/u/s!AikPceQOhqFEhAQ4rRsY7aWI1MVh?e=bgzjJF
Thanks.
Hi,
Can you help me with some sample data.
Thanks.
ID Target Minute
1 -500 0
this tabel has only one recoad and at a given time either target or minute column has 0. Both columns cannot have values at the same time. I can add some other columns if required.
Thanks a lot for looking at this. If you need more infomation please let me know.
Hi,
I have created the below pbix.
Check if this is what you need.
https://1drv.ms/u/s!AikPceQOhqFEhAQ4rRsY7aWI1MVh?e=bgzjJF
Thanks.
I cannot open it from my work computer. would you be able to flick the file to my email as on this account.
Thanks a lot
Can you help me with the email id? I am not able to find it.
Thanks.
Hi Champion,
It is amal.eranda@gmail.com
I really appriciate your help.
Regards
File Sent.
Thanks.
You are a Champion.