Forum Discussion
Money column displays without trailing zero
I have a report that displays values from a SQL Server money data type column. These columns display in Power BI without trailing zeros and it looks terrible.
Impact
$8001.61
$8500.3
$7500.25
etc.
Everything was correct, but Power BI was - for some reason that I would really like explained to me - using the default 'auto' format option (beneath the datatype) of NOT using two zeros for displaying currency.
So the problem wasn't a datatype problem, but a problem with Power BI defaulting to a 'faulty' format option for currency.
7 Replies
Hi duncfair,
Are you formating the column / measure as currency ??
Check it out:
https://community.powerbi.com/t5/Desktop/Formatting-measure-values-as-currency/m-p/17254
Ricardo
No.
The column has a money datatype in the Source (SQL Server) and keeps trailing zeros when queried from there or viewed with SSMS, etc.
When presented in Power BI, however, the column has trailing zeros dropped - even though Power BI displays a $dollar sign.
Can you print an image of this in Power BI, also the image of a table struture/sample data ?
