cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mahra-in Regular Visitor
Regular Visitor

Limit the Decimal of a Measure used in Text Box

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Limit the Decimal of a Measure used in Text Box

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

3 REPLIES 3
SivaMani Senior Member
Senior Member

Re: Limit the Decimal of a Measure used in Text Box

@mahra-in,

 

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

 

decimal.PNG

mahra-in Regular Visitor
Regular Visitor

Re: Limit the Decimal of a Measure used in Text Box

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 points1.PNG

 

2.PNG

 

still the result is same

 

Community Support Team
Community Support Team

Re: Limit the Decimal of a Measure used in Text Box

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors