Number Visualization

[Anonymous]

Hi All,

I have odd requirement to fulfil

Values in DB	Client Requrement
100.25	100.25
15.357	15.36
15	15
13	13

can this  number format achievable ?

[danextian]

You may format by selecting a field (column or measure) then going to Modeling tab. 

[Anonymous]

Appreciate ur @danextian  reply
I will describe my more  

As my knowlage,

under the same column heading, two data format need to show

decimal number with 2 decimal places 
100.25
15.36

And aslo 

15
13
need to visualise like whole number

end result need to be
100.25
15.36

15

13

how can i achive this?

[danextian · Accepted solution]

You will need to create a measure or a calculate column to format  the numbers. Try this:

Measure =
IF (
    SUM ( Table[Number] ) = INT ( SUM ( Table[Number] ) ),
    FORMAT ( SUM ( Table[Number] ), "#,#" ),
    FORMAT ( SUM ( Table[Number] ), "#,0.00" )
)

or

Column =
IF (
    Table[Number] = INT ( Table[Number] ),
    FORMAT ( Table[Number], "#,#" ),
    FORMAT ( Table[Number], "#,0.00" )
)

Please take note that the result will be of text data type.