Power BI Fixed Decimal has two digits, not four

Viewed 116

All documentations and tutorials out there mention that transforming a table column to Data Type 'Fixed Decimal' will make it have four digits to the right of the period symbol.

However, when I use this type, it only shows two and the Power Query for that step has:

= Table.TransformColumnTypes(myTable,{{"fieldName", Currency.Type}})

Was the default behaviour changed or do I need to first set some setting to get four? I tried this with multiple files.

0 Answers
Related