Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kellysolutions
Frequent Visitor

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

1 ACCEPTED SOLUTION

@kellysolutions , Log a new Idea on issues. So that it can be checked for March 2021 releases

View solution in original post

4 REPLIES 4
kellysolutions
Frequent Visitor

OK I'll post it there. Thank you

amitchandak
Super User
Super User

@kellysolutions , Please check as anyone else reported this issue at -https://community.powerbi.com/t5/Issues/idb-p/Issues

If needed log a new one.

Sorry I dont understand. What do you mean log a new one?

@kellysolutions , Log a new Idea on issues. So that it can be checked for March 2021 releases

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors