Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Currency not showing two decimals

Having an issue with the currency type in the edit queries. I have it set to currency but it doesn't show two decimal places. This is with the new June update; it was working fine before. See photo.Tried removing nulls to 0 but no effect.Tried removing nulls to 0 but no effect.

Status: Needs Info
Comments
v-yulgu-msft
Employee

Hi @rbartlejr ,

 

I didn't find any to set currency for decimal data. How did you achieve that? Please provide more repro steps. My desktop version is 2.70.5494.761 64-bit (June 2019).

 

Best regards,

Yuliana Gu

v-yulgu-msft
Employee
Status changed to: Needs Info
 
rbartlejr
Helper III

It's actually fixed decimal point. I thought it was previously able to set to two decimals automatically (like currency), but may have been incorrect. I fixed it on the report formatting; I just remember it adding those decimals when I was importing data - I guess not.