Forum Discussion
Custom format number for a measure
Hi
I think this is a silly question but I couldn't find any solution.
In a column I have whole number as decimal numbers too. I need that in a matrix, the whole numbers were displayed without decimals, and decimal numbers with decimals. Is is posible through any custom format ?
Currently are showing like this:
100,00
2,50
76,38
10,00
I need:
100
2,50
76,38
10
Thanks in advance,
Regards
4 Replies
- camargos88
Community Champion
- gustavo80
Helper III
Thanks, that was exactly what I need!!
Regards
- amitchandak
Super User
gustavo80 , refer if this can help
https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
- gustavo80
Helper III
hi amitchandak ,
Thanks, I have read that doc previous to my post, but I couldn't find a combination that suits for my need. Is there anyone ? I need that my custom format works in a little differente way for whole numbers or decimal numbers.