Skip to main content

Power BI

New

Default Decimal Currency

Vote (4) Share
Matt Allington's profile image

Matt Allington on 05 Mar 2019 11:04:52

When you set the data type for currency for a measure or a column, the default number of decimal points is Auto. If the value is a floating point value, then you will get something like 12.385923492345

This is not very useful for a currency format. It would seem to me to make more sense to either have the default as 0 decimals or 2 decimals.