Forum Discussion

SHAKEDALROY's avatar
SHAKEDALROY
Helper I
5 years ago

Negative Numbers

Hi,   I'm trying to add a minus sign or  Parenthesis to the neagative numbers in a measure on my table visual. Do i need to do it through DAX? beacuse i don't find a way to do it on the report.. ...
Need Help
LP2803's avatar
LP2803
Responsive Resident
5 years ago

SHAKEDALROY Can you share an image of what you are trying to do? and how you want the output to be?

 

 

  • SHAKEDALROY's avatar
    SHAKEDALROY
    Helper I
    5 years ago

    LP2803 for ex - the second line in the Change From PM column is a negative number but it doesn't show it.

    it suppused to be -24,986 or (24,986)

     

    • FarhanAhmed's avatar
      FarhanAhmed
      Community Champion
      5 years ago

      Make sure that you are not using ABS (Absolute) in meausre 

    • LP2803's avatar
      LP2803
      Responsive Resident
      5 years ago

      SHAKEDALROY 

       

      I'm unable to produce your issue with my sample data.

       

      But I think this might help

      = Format([Measure],"#,##.#0;(#,##.#0)")