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 everyone, hope you are well 🙂
I'm trying to make a measurement that, depending on the daily variation, displays an icon for positive or negative.
But if the number the variation has decimal places (-0.05) does not work.
Even with the negative number in percentage this occurs.
Does anyone have any idea what to do in these cases?
thx
Solved! Go to Solution.
Hi, @Anonymous
I checked your measure 'indicador base64' and found that you have offset the calendar table by one day.
DateADD(
oCalendario[Date],
-1,
Day
)
You may need to remove this filter. The code in the SWITCH section is sufficient for your needs.
Best Regards,
Community Support Team _ Eason
Hi @Anonymous ,
Usually defining Indicators should be done on the Number and not on the percentage.
i.e. Control the display of Indicator using the Number by keeping the value as a number datatype and just for display make the number as percentage
May be this could solve this issue!!
Hi, @Anonymous
I checked your measure 'indicador base64' and found that you have offset the calendar table by one day.
DateADD(
oCalendario[Date],
-1,
Day
)
You may need to remove this filter. The code in the SWITCH section is sufficient for your needs.
Best Regards,
Community Support Team _ Eason
Thx ❤️
If you notice in the first image my attempt is with decimal number
@Anonymous , Try to use unichar like this, see if that can help
/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)
/////Arrow Color , use in conditional formatting using field value option
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)
UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50
Thanks for replying, my icon works fine, my problem is with the values in the comparison. Note that the value is negative but the icon points to positive! I believe it is a problem with decimal numbers since this only happens when the value has places to the right (-0.05, -0.065, ...)
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |