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.
Dear Community,
take a look on the below pic.
Growth new measure with unichar code is turning up weird.
Growth new to be showed as same as Growth with green and red indicator.
below are the measures i have used to do that, unfortunately something is not working correctly
Arrows = SWITCH(
TRUE(),
ISBLANK([Growth])
|| ISBLANK([Growth]),BLANK(),
[Growth] = 0, "No Data",
[Growth] >= 0,UNICHAR(9650),
[Growth] <= 0,UNICHAR(128315),
BLANK()
)
Growth =
VAR __BASELINE_VALUE = SUM('Inbound'[TER_PFYTD_Constant])
VAR __VALUE_TO_COMPARE = SUM('Inbound'[TER_FYTD_Constant])
RETURN
IF(
NOT ISBLANK(__VALUE_TO_COMPARE),
DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)
)
Growthnew = CONCATENATE(CONCATENATE([Growth],"%"),Inbound[Arrows])
Solved! Go to Solution.
I think i figured it out, my measure should look like below
Growthnew =
CONCATENATE ( FORMAT ( [Growth], "0.0%" ), Inbound[Arrows] )
Hi @vjnvinod
You may try below measure:
Growthnew = CONCATENATE ( FORMAT ( [Growth], "percent" ), Inbound[Arrows] )
Regards,
Cherie
This is helpful, but i see the decimal point is coming as 2, as a result of the measure you have shared.
6.82% etc
any how to round this to 1 decimal point? thanks for your help.
I think i figured it out, my measure should look like below
Growthnew =
CONCATENATE ( FORMAT ( [Growth], "0.0%" ), Inbound[Arrows] )
You need to FORMAT the GROWTH measure when you concatenate it to your symbol. It's nothing to do with UNICHAR, it's just showing as the exact decimal result of your divide calculation
I don't think it's anything to do with the UNICHAR, it's just that the result of the GROWTH calculation is showing as an unformatted decimal number with your character tagged on the end. You need to give it a format .
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 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |