Both rounding and decimal numbers

[Anonymous]

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.

[Fowmy · Accepted 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 🙂

YouTube, LinkedIn

[danextian]

This is something I never got to try until today. 🙂

[danextian]

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" )
)

[amitchandak]

@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