Forum Discussion
duncfair
Helper IV
Helper IVMoney 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 ...
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.
duncfairHelper IV
Helper IVthis site doesn't allow me to upload images.
ricardocamargos
Continued Contributor
Continued Contributor