Forum Discussion
kellysolutions
5 years agoFrequent Visitor
Number formatting changes after Power BI Update
- If you want to display a negative value in brackets (parenthesis), as most accountants and financial people do, you have two choices.
- You can create a format, e.g. £ ##,##0; (£ ##,##0); or you can use the DAX Format command.
- DAX Format turns the number into text and so we create the format code.
- After the March 2021 update, our formats were corrupted and turned into something like \£\#\#\,\# etc.
- Does anyone know why this happens and how can I prevent it? Using DAX Format is not an option.
- Also why donesn't Microsoft just provide the alternative format type?
Thank you,
Paul
kellysolutions , Log a new Idea on issues. So that it can be checked for March 2021 releases
4 Replies
- amitchandakSuper 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.
- kellysolutionsFrequent Visitor
Sorry I dont understand. What do you mean log a new one?
- amitchandakSuper User
kellysolutions , Log a new Idea on issues. So that it can be checked for March 2021 releases
- kellysolutionsFrequent Visitor
OK I'll post it there. Thank you