Custom format number for a measure

[gustavo80]

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

[camargos88 · Accepted solution]

Hi @gustavo80 ,

Check this post:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-number-of-decimal-places-and-thousand...

[gustavo80]

Thanks, that was exactly what I need!! 

Regards

[amitchandak]

@gustavo80 , refer if this can help

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

[gustavo80]

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.