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.
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