Forum Discussion

kellysolutions's avatar
kellysolutions
Frequent Visitor
5 years ago
Solved

Number formatting changes after Power BI Update

  1.  If you want to display a negative value in brackets (parenthesis), as most accountants and financial people do, you have two choices.
  2.  You can create a format, e.g. £ ##,##0; (£ ##,##0); or you can use the DAX Format command.
  3. DAX Format turns the number into text and so we create the format code.
  4. After the March 2021 update, our formats were corrupted and turned into something like \£\#\#\,\# etc.

  5. Does anyone know why this happens and how can I prevent it? Using DAX Format is not an option.
  6. Also why donesn't Microsoft just provide the alternative format type?

    Thank you,

Paul

4 Replies