March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 ?
Solved! Go to 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.
Proud to be a Super User!
You may format by selecting a field (column or measure) then going to Modeling tab.
Proud to be a Super User!
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?
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.
Proud to be a Super User!
User | Count |
---|---|
122 | |
99 | |
89 | |
74 | |
66 |
User | Count |
---|---|
139 | |
115 | |
114 | |
98 | |
98 |