Formatting

[JamesBurke]

Hi all , 

Overview Card 2 = 
VAR _Change = CALCULATE([Card 2 %])
RETURN
FORMAT(_Change, "##.## % ") & " " & IF(_Change > 0 , "▲", "▼")

Im wondering if anyone can help why when the percentage reaches 0. it does not include zero at the start , it makes the visual look confusing , is there some wrong with my formatting measure ?

Card 2 % = 
VAR __BASELINE_VALUE = [Daily Average all]
VAR __VALUE_TO_COMPARE = [Daily Average]
RETURN
	IF(
		NOT ISBLANK(__VALUE_TO_COMPARE),
		DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)
	)

this is my Measure used in the previous measure for some context , it has no formatting applied to them. 

[BIstvan · Accepted solution]

@JamesBurke  In the Overview Card 2 try the below.

Overview Card 2 =
VAR _Change = CALCULATE([Card 2 %])
RETURN
FORMAT(_Change, "Percent") & " " & IF(_Change > 0 , "▲", "▼")

[BIstvan]

@JamesBurke  See below a second solution which should work.

Overview Card 2 =
VAR _Change = CALCULATE([Card 2 %])
RETURN
FORMAT(_Change*100, "0.00"&"%") & " " & IF(_Change > 0 , "▲", "▼")

[Anand24 · Accepted solution]

@JamesBurke ,
That's the default behaviour of Format DAX function when provided exact format. Here's what you can do apart from the solution @BIstvan provided:

__Zero_Format_Test =
VAR _Change = 0.002002
Return
IF(
    _Change < 1,
    FORMAT(_Change, "0.## % "),
    FORMAT(_Change, "##.## % ")
)
& " " & IF(_Change > 0 , "▲", "▼")

Output: 

[BIstvan]

@Anand24  the perfect example why DAX is amazing.

[BIstvan · Accepted solution]

@JamesBurke  In the Overview Card 2 try the below.

Overview Card 2 =
VAR _Change = CALCULATE([Card 2 %])
RETURN
FORMAT(_Change, "Percent") & " " & IF(_Change > 0 , "▲", "▼")

[JamesBurke]

Hi @BIstvan , 

Thankyou for the quick response , this worked great 🙂 

Thankyou !!!