Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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 🙂
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.
@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!
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.
Hi But how can we pass it to text ?
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.
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, & 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.
My bad, I forgot to test it before posting :).... Yes you will have to use the & operator as well as FORMAT() based on your needs as @greggyb mentioned.
Yes, I'm aware about the language, thanks.
I was just hoping to have a more direct solution.
@SabineOussi as far as I know text expressions are not yet available but as you mentioned you can do some workarounds.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |