Formatting a Measure is limited


Well-known Member
I created a DAX measure on Excel 2016 and right click edit the number formatting option is quite limited.
For example, for negative if I wish to display (1,234) that seems not an option but instead only -1,234 is possible.

Is there an alternative way we can achieve a custom formatting on it ?

I know I can clic "Value field setting", but once I set it, if I remove the setting during re-drawing of PT and then later bring it back then it revert to the original formatting..


Well-known Member
If you put this into a custom format for the cells it will do what you want: #,##0;[Black](#,##0)

Some videos you may like

This Week's Hot Topics