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,
Is it possible to show both rounding numbers and decimal numbers for the same measure/value column?
If a value is 4.0 then showing 4 and if value 3,5 then showing 3,5, so there is a combination of decimals and whole numbers in the same table/matrix.
Solved! Go to Solution.
@Anonymous
Select your measure or the column, Under formatting section of the ribbon, apply format #,##0.#
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Select your measure or the column, Under formatting section of the ribbon, apply format #,##0.#
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
This is something I never got to try until today. 🙂
Proud to be a Super User!
Hi @Anonymous ,
I don't think that 's currently possible. As a workaround, you may create another measure that will render the referenced measure as text with and without decimals. Example:
MEASURE as text =
IF (
//INT rounds down a number to the nearest integer
//if [Measure] is equal to its integer form then return as a whole number else as a decimal
INT ( [Measure] ) = [Measure],
FORMAT ( [Measure], "0" ),
FORMAT ( [Measure], "0.00" )
)
Proud to be a Super User!
@Anonymous , you may have to create a measure checking that with if , but it might become text
Refer if this can help
https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |