Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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....)
Solved! Go to 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.
@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)
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.
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.
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.
@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)
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 - You could use something likw the below -
Measure = "Map represents "&FORMAT([Country of Residence %], "#.#%")&" of Live users"
@gpiero Unfortunately you can't do that in text box but you can use Card visual and use your measure in that card visual.
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |