cancel
Showing results for
Did you mean:
Member

## text box and a value come from a measure

Is it possibile combine a value come from a measure inside a text box?

for instace, let us suppose I would like to put a text box:

"Last week we have closed 745 ticket"  where 745 is the value come from  IDClosed = COUNTROWS(FILTER( etc etc....)

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super Contributor

## Re: text box and a value come from a measure

@gpiero Unfortunately you can't do that in text box but you can use Card visual and use your measure in that card visual.

Super Contributor

## Re: text box and a value come from a measure

@gpiero This should work...

`Text Measure = "Last week we have closed " & [IDClosed] & " tickets!"`

See picture... In a Table and in a Card (works also in Matrix and Multi-row Card)

6 REPLIES 6
Super Contributor

## Re: text box and a value come from a measure

@gpiero Unfortunately you can't do that in text box but you can use Card visual and use your measure in that card visual.

Super Contributor

## Re: text box and a value come from a measure

@gpiero This should work...

`Text Measure = "Last week we have closed " & [IDClosed] & " tickets!"`

See picture... In a Table and in a Card (works also in Matrix and Multi-row Card)

Member

## Re: text box and a value come from a measure

@Sean

great indeed.

This is the solution I was looking for.

Thanks again

Frequent Visitor

## Re: text box and a value come from a measure

For anyone still searching for this, I have created an idea on ideas.powerbi.com to create variables in text boxes based on measures. Please upvote to get this feature added.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33374140-using-measures-to-dynami...

Member

## Re: text box and a value come from a measure

Hi @Sean  I just found your solution to combining text and a measure into a single measure.

The measure I am including is a percentage: [Country of Residence %] which I have modelled to 2 decimal places and works fine outside of the below Measure it is 3.52%.

However when I use the below measure, the result shows the percentage as 3.52752016487226E-02

`Measure = "Map represents "&[Country of Residence %]&" of Live users"`

Can you suggest anything?

Thanks!

Jemma

New Member

## Re: text box and a value come from a measure

@heytherejem  - You could use something likw the below -

Measure = "Map represents "&FORMAT([Country of Residence %], "#.#%")&" of Live users"

Announcements

#### New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)