Forum Discussion
Currency 2 Decimals
Is there a way to change the 'Auto' option for Currency to '2 Decimals' by default instead of doing it manually each time when creating a measure?
Hi Anonymous ,
I think it's not available for us(uers) to change such a underlying logic ,which is designed by developer.
You may use the following formula to directly change the format:
Format = CONVERT( FORMAT(SUM('Table'[Value]),"#.00") ,CURRENCY)Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- mahoneypat
Microsoft Employee
Not sure if that is an option is you create a custom JSON theme file, but you could use this script in tabular editor to convert all selected measures to a 2 digit currency type.
Selected.Measures.FormatString="\\$#,0.00;(\\$#,0.00);\\$#,0.00";
Pat
Hi Anonymous ,
I think it's not available for us(uers) to change such a underlying logic ,which is designed by developer.
You may use the following formula to directly change the format:
Format = CONVERT( FORMAT(SUM('Table'[Value]),"#.00") ,CURRENCY)Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
