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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |