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 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.
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |