I love dropping dynamic labels into text boxes - so handy! Although I think in both these cases, I'd pop the measure in the Title field of the visual instead of a separate text box (click the fx thing and select the measure).

I've been using this and it has become a standard in my templates for the page header. Perfect for summarizing the key takeaways dynamically on the page. One requirement you need to keep in mind is that Q&A must be turned on for your model. I had a model recently created by another colleague and Q&A was turned off for some reason and the measures would not populate.

That is really nice. I'd been using the card visual for ages, but this makes more sense. When you want to display text, you should be able to use a text box.

It's a really cool option in Power BI. I've been using this for the sales dept reports. It can save a lot of time, espacially when people need to create weekly presentations or things like that.

I have been doing this for at least the past couple months and it is now part of my standard report template as there are so many good use cases for it.

You can actually mix some text with measures values in the text box. Also, you could use it with some dax, such as selected value. So you wouldn't need to create a measure for that.

Finally something I've been doing before Patrick has

been using the dynamic txt function from this to show the date the report was last run or the date range of a field in the report for a while now. really good when combined with min/max on dates so you can easily show date ranges within 1 text box. Don't even need to create a measure for min/max date, just build it into the dynamic function.

You are bringing the party! Thanks Patrick

Interesting use of Text box here, wonderful. It kind of reassures the user whether they are looking at the data they intend to look at. 👍🏻

Yes, I have used text box with measures while converting reports from Cognos to Power BI to give similar parameters display.

Nice video, I wanted to mention you can also add emojis to your formulas as well... Once you have your measure's formula box open press [For Windows users: Win + Semicolon or Win + Period] [For Mac: Command + Control + Space] then start typing the emoji name (ex. Calendar) you want, then click the emoji you want to insert "📅". Just make sure you wrap it in quotation marks. This makes it easier than using the UNICHAR function to insert simple emojis.

You are the man! Great help, thank you. I am a pretty good user of Excel and data analysis learning PowerBI has been different and I think more difficult. Thanks

Hi Patrick, thanks for the video it's informative as always. I have used it before in my reports but there are some challenges like we have to have the Q&A enabled and this won't work if we are using measure groups via Tabular editor. Am I missing something is there a workaround?

Great video! There is actually a cool custom visual called 'HTML Content' that lets you use HTML code in a measure so you can format text used in cards :) I've always found using measures in text a bit unpredictable - weird white spaces and such..

I was hoping someone would have pointed out the blue underline that comes along as default with the text with this method and hopefully a solution to it. The stubborn line is also visible in the recorded video. Love the trick, but not able to get rid of that line making it useless. If anyone knows how to, please respond..thanks.

Hi Patrick! I love the feature of adding values to text box and I use it a lot. However, I noticed they stop working once I introduce Calculation Groups to the report. Have you got any ideas for that?

Dynamic text boxes aren't available to me at the moment, so I've used a Multi-row card visual, which does allow for left-alignment of the text etc.

You Rock, Patrick. Thanks for sharing

As always you are awesome👍

Most of the times, it will not work when you have defined format strings for calculation items in a calculation group. This affects only for text output from a measure, like in the example here. The measure will not return the text value in the text box. But if the output from the measure is a number, this issue is not there.

Before it was possible to use a measure with a text box, Advance Card had been used for the same purpose as it offered left alignement not available in a card visual.

This is great, I’ve been doing something similar in Excel for years ... we’ll need to rework quite a few of our PBIXs!

For titles and visuals I prefer using the format dax function where you can have dynamic titles as a measure

Wow this would be awesome to conditionally show the measure details (like the dax code) for a visual to help with documentation and showing the user the details

You rock Patrick!

Hi Patrick. I have been learning a lot about Power BI from your videos. This particular video was very helpful. I used the text box to input a value from a measure I created. I used this option since the smart narrative couldn't be used since the narrative itself can change in a way that smart narrative cannot handle in this particular case I am working with. What I need help with now is being able to have the text box (with narrative) only visible if the value of the measure is not equal to zero. When it is zero there is no explanation necessary, but if it is not equal to zero (whether negative or positive) I want the text box to show and to be able to change the narrative but keep the measure value. Is there a way to conditional format the text box and maybe make the font (narrative and measure value) white against the white background of the text box so that it appears like the area is blank, OR a way to have the text box only visible and printable if the measure value included in the text box is not equal to zero (ie. make the text box disappear if the measure value is zero)? The measure is dependent on slicers on the page, and I want users to be able to edit the text box narrative (if the measure in the text box is not zero) as the explanation may vary.

Hi, can we copy the content from the textbox? I tried but couldn't find a way. Thanks for the help!

Awesome !

Is there any way to remove the underline below the dynamic text?

Amazing !! Microstrategy do the same but you just need to drag and drop de measure into the text box. Easy like a sunday morning ;)

What it takes to get to the point directly? (2:28)

The music/sound in the background makes is distracting and it's difficult to take in your content, which is great by the way.

I love this feature when it first available on the update, cuz I always find it difficult to format dynamic text to card in terms of align formating. But sadly this feature isn't available on report server

Love your work!

Cool - you are always on time for the party :)

BUT you can't get rid of the line below the text which is soooo annoying!

Can we have a custom color like Red for negative numbers and Green for Positive numbers?

I'm struggling with this feature not wanting to use the measures I've made. When I go to add a value in the text box, it seems (to me) to be pot luck whether the measure I've made actually shows up to be selected. In some cases, even if I right the specific [measure name] in the field box, it just returns a blank or an error. I have no idea why this is... some people are mentioning it has something to do with the Q&A function? It's very frustrating, because my measures work perfectly in a card, but refuse to pull through into a text box for some reason... Any suggestions would be much appreciated!

The videos are great....I still find hard to watch to finish them...

Thanks - great tip

Hey Man. March 2024 The Copy Data table Option is disable is another option to Copy Data Table

Great video!

What if I want to show the text box only when the user clicks on a shape from a shape map?

This is only for the visuals; the title from the formatting pane has the ability to take a measure to display text. Am I missing anything here?

you never disappoint me.

Great tricks paTrick ;)

Hi , i am not able to find fx function in new power bi update in column colours under visual effects

Been using this for a while! Very cool, you don't actually need to create a measure either. You can directly type static text required into the text box and create a value for the country selected.

how does one get rid of the blue line in the text box ?

Hey ,big fan of your video ..wanted to know is there a way to remove 'line' that is coming below text in text box ..Thanks in advance .

LOVE This!💙💙💙

Instead of a 'non-formatable' Card, you could use a Multi Row Card which is already left-aligned... Could you do a video on that, guys??

nice one dude!

Hey Patrick & Adam...love you guys. Question...I would like the title of all of my pages in PBI to be the same and be dependent on a Month / Year selection on a filter that is in a hidden page. Is that possible? I know about changing titles of visuals with slicers that are on the page, but nothing I have found to have every page's title be the same based on an "information slicers" on another page that isn't made to be displayed, but the user can simply select and all the report titles on all the pages change. Any help?

Thanks Patrick for this useful trick. however when i tried to use this same the text coming underlined and i am not able to remove that by any means. could you please help on this

It did not work on my end. I used it as a title but it is choosing the first value/data in the slicer, which is not what I wanted. I wanted that it will only show the value when I chose the value I want from the slicer

Is the text box influenced by changes to a theme file? I use the card visuals because they get picked up by text formatting options form the theme file whereas it used to be that text boxes did not.

Will this work when you are using calculation groups to dynamically change the measure a visual uses or will the title be overwritten by the calculation items value?

Great! But, that underline is nagging. Couldn't find a way get rid of that. Any ideas?

Thank you for the video. I was wondering if there is any way to show the text temporary. My business case is that I want to remind the end-user that they are working with sensitive data so I want the message to appear when they open the report and disappears after x second. I tried to do it in Javascript but couldn't find a custom visual which can run JS, and the HTML5 visual didn't support JS.

Q: I use a card visual to show a page title based on the slicer selection however some selections have more characters than the other. Is there a way to have the font size automatically adjust based on the amount of text in the card? Thanks!!

Hi Team, When I am going to select more than 2 items from slicer then the title of a chart is not showing properly. Could you please help me on this.

Hey Patrick. Is there a way to use shape maps as slicers in Power BI ??

Actually with the text box you don’t even need to create the measure. Just plain text, you click value and can the type “selected values” and the attribute you need ;)

I added one for my date range and now if i try to add another dynamic value nothing shows up as options (yesterday it was working fine) Any ideas what is going wrong?

But the underlines under measures in a text box cannot be turned off. That is why I almost always use buttons for this scenario.

That's amazing.

Hello Patrick, It has been a while I am trying to find a way to import the activity report data, any idea how to? it would be cool to build reports on top of that!

You only have cool videos, tnx!

I use this to put the selected year (parameter) in the title of the report page. You don't even need a specific measure, you can mix normal text and the reference to an already existing measure.

The thing I don't get it. It's why when I create my measure the text box QA don't recognize it. =/.

What other requirements are there to make this work? I have enabled Q&A for the dataset, but is still unable to find my measures in the dialog box. I am running Version: 2.103.881.0 64-bit (mars 2022) The measure is local. I am using a live connection to a published dataset.

I just use custom visual: Text Enhancer by MAQ Software -- because it does all this and more. And it's free, certified and awesome! (i am not affiliated with MAQ)

Strangely, I've never used anything else but textboxes in this regard.

What if I just want to add a normal title to my report? What if I want something to show at the top like "end of month report"

I need help I have a simple case but I can't solve it yet please help if there is a solution for example I have this kind of power Code Name Percent 111 A 50% 101 B 30% 000 C 20% After I filter it will be like this, the total percent will be accumulated to the earliest section in the name column: Code Name Percent 111 A 80% 000 C 20% Please help

Hey all! Does anyone happen to know how to create a visual to compare my data? Let’s say I have a single list containing a specific metric in an Excel field and another field saying what month each metric applies to. Example: Burger King sells 100 sandwiches in Jan, 120 in Feb, and 300 in Mar. McDonald’s sells 200 sandwiches in Jan, 220 sandwiches in Feb, and 450 sandwiches in Mar. How would I create a visual off those 2 fields to show the +/- of sandwiches sold for each company where you can utilize a slicer to pick 2 months you want to compare +/- of sandwiches sold out of the calendar year? Is this possible without creating new fields in Excel for sandwiches sold for each restaurant each month? (E.g. sandwiches sold in Jan, sandwiches sold in Feb, sandwiches sold in Mar.)

yep, can be more intuitive than buttons, however, it seems to me important to point out that this won't work if you are using some RLS in your report...

Datatype of .pbix

Have you tried using "Shapes" instead? I have found it to be more flexible when it comes to formatting. Vertical alignment, padding and text direction/rotation are some of the added perks. Parker @ BI Elite showed it sometime back (kzfaq.info/get/bejne/qciXZK6h1LWmlKc.html).

late to the party, sorry 😉