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

Highlighted
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

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 143 members 2,072 guests
Recent signins: