Forum Discussion
Dynamic Text
Hello,
Is there a way that I can create a dynamic text within the text box?
In other words, let's say I want to display the following:
There are @numberoftickers submitted by @numberofusers and managed by @numberofadmins
@numbers will be a count of certain fields.
I know that I can create a card of the desired count and a text box with a specified space and put them on top of each other so that they appear as they're written in one sentence.
But is therer a better way to do it? Like sort of a hyperlink to columns?
Thanks,
Sabine O.
What you can do is to create a measure like
TextMeasure = "There are " + [numberoftickers] + " submitted by " + [numberofusers] + " and managed by " + [numberofadmins]
Now you can place this measure in a text box and that should show the desired result. Using text based measures is a handy technique in scenarios like this.
14 Replies
What you can do is to create a measure like
TextMeasure = "There are " + [numberoftickers] + " submitted by " + [numberofusers] + " and managed by " + [numberofadmins]
Now you can place this measure in a text box and that should show the desired result. Using text based measures is a handy technique in scenarios like this.
The problem with using a card is that you lose the control over font over individual segments. For eg: if I wanted to display the measure value in bold and different color from rest of the text, or go to next line, I cant do that.
So basically, being able to concat text and measure directly in text box would be good.
The other problem with using a card is that you lose all formating capabilities. (or at least to the best of my knowledge).
I have not been able to left justify the text in a card.
SqlJason, & is the concatenation operator in DAX; + is not overloaded as in SQL.
As an additional point, depending on the measure being used to provide the numeric portion of this string, you may find a need for FORMAT(), which allows you to use a format string to alter the display of a numeric or date value.
Chris Webb has blogged about a fantastic solution that listens to slicer values to dynamically create a title. Very similar solution using a card with no category that "sits on top of" of chart, but a little more robust.
SqlJason how do you set a textbox to the value of a measure? I was able to create a measure that returns a dynamic title using your method but I don't know how to set a textbox a measure. I was able to do so using the "card" visualization but I don't want to use that visualization because it uses the name of the measure as a default title.
MrDataGeek it is a card visualization and not a textbox. You can turn off the category label, turn on the title and put the title text you want.
Thanks SabineOussi! I figured that out last night and I was about to update my question before I saw your response. I did not initially think to turn off the "category label". I appreciate your help!
This feature was added in mid 2021
You can create dynamic text within text boxes without any coding or extra variables.
Someone talks about it here... https://www.wiseowl.co.uk/blog/s2887/text-box.htm
This discussion is still the number one Google result so thought I'd provide an update 🙂
SabineOussi as far as I know text expressions are not yet available but as you mentioned you can do some workarounds.
For everyone that's searching for this. I have created filling in parts of text boxes dynamically as an idea on ideas.powerbi.com. Please vote on it so that we can have this useful feature. Link below.
