Forum Discussion

JamesBurke's avatar
JamesBurke
Helper III
2 years ago
Solved

Formatting

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 ...
  • BIstvan's avatar
    2 years ago

    JamesBurke  In the Overview Card 2 try the below.

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

  • Anand24's avatar
    2 years ago

    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: