text box and a value come from a measure

[gpiero]

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

[ankitpatira · Accepted solution]

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

[nathan-giullian]

I'm sure this is a long overdue response, but you can use measures in a text box in Power BI by adding it as a value. It does take a while for the visual to recognize the measure but once it does you can save and it works great! You can see in the screenshot that once the measure is outlined in blue you can give the value a name and save it. Hopefully this helps 🙂

[MasonAldrich]

To include a count of all rows in a text box, create a new column in the data that is just '[name] = 1' and then take the sum of this column in the text box value.

[Anonymous]

I know this is an old thread, but I was trying to do something similar by using a measure to update the title lines on all pages.  I found that the Advanced Card let me build a card that also allowed for greater formatting capabilities such as right justifying the text.  Anyone searching for a solution here might want to take a look.

[SemG]

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

[Sean · Accepted solution]

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

[Anonymous]

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

[Anonymous]

@Anonymous  - You could use something likw the below - 

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

[gpiero]

@Sean

great indeed.

This is the solution I was looking for.

Thanks again

[ankitpatira · Accepted solution]

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