Limit the Decimal of a Measure used in Text Box

[mahra-in]

Hi

I have to dispaly a card with value from a measure but the value comes with decimal which I dont want

Text = "Data Not available for " &[No Data]*100& "% of Entries"

The output Im getting is 

Data Not available for 13.35457288383%

Is there a way to limit to the decimal or no decimal so that the result could be

Data Not available for 13% of Entries

Please help

[SivaMani]

@mahra-in,

Click the field and change number of decimal place under Modelling tab,

[mahra-in]

The filed No Data is set with 0 in Decimal Places but when I use the field in between text ic omes with many decimal points

still the result is same

[Anonymous · Accepted solution]

Hi @mahra-in,

Since your measure return the text value, I think you can use format function to formatting decimal number part.

Please take a look at below link to know more about format measure:

Custom Numeric Formats for the FORMAT Function (DAX)

Sample:

Text format =
"xxxxx"
    & FORMAT ( [No Data] * 100, "0.00" )
    & "xxxx"

Regards,

Xiaoxin Sheng