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.
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.
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.
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.
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.
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?
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?
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.
It's a great idea, but for so reason it doesn't find measures (when I type the measure name after hitting the "+" sign...). I have no idea what the problem could be.
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.
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
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!
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
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.
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.
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 ;)
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
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?
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!!
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.
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?
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.
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
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?
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!
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)
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.
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.)
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
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...
Hello Benjiman, thanks for the comment. I just tested this with RLS in the report and it worked. Now with OLS it does not work. Can you please elaborate on your scenario where it does not work? Really interested in reproducing.
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 (ua-cam.com/video/sbg1KpoOBds/v-deo.html).
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.
Yeah the card has some limitations, but this make it so easy.
Finally something I've been doing before Patrick has
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.
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.
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.
Was going to ask around this. How do you combine static and dynamic text. Do you just include the static bit in the formula?
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.
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
The music/sound in the background makes is distracting and it's difficult to take in your content, which is great by the way.
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. 👍🏻
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?
You are bringing the party! Thanks Patrick
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.
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?
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..
Is there any way to remove the underline below the dynamic text?
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.
You Rock, Patrick. Thanks for sharing
It's a great idea, but for so reason it doesn't find measures (when I type the measure name after hitting the "+" sign...). I have no idea what the problem could be.
This is great, I’ve been doing something similar in Excel for years ... we’ll need to rework quite a few of our PBIXs!
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.
Hi, can we copy the content from the textbox? I tried but couldn't find a way. Thanks for the help!
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.
For titles and visuals I prefer using the format dax function where you can have dynamic titles as a measure
BUT you can't get rid of the line below the text which is soooo annoying!
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
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!
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
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??
Can we have a custom color like Red for negative numbers and Green for Positive numbers?
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.
Cool - you are always on time for the party :)
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.
Hey Man. March 2024 The Copy Data table Option is disable is another option to Copy Data Table
Hi , i am not able to find fx function in new power bi update in column colours under visual effects
What if I want to show the text box only when the user clicks on a shape from a shape map?
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 ;)
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?
As always you are awesome👍
Thanks for watching
The videos are great....I still find hard to watch to finish them...
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 .
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
You rock Patrick!
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?
What it takes to get to the point directly?
(2:28)
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!!
Hey Patrick. Is there a way to use shape maps as slicers in Power BI ??
Great! But, that underline is nagging. Couldn't find a way get rid of that. Any ideas?
you never disappoint me.
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.
Yes! I like taking a field or measure and dividing by 1000 or 100,000 to get my K and M display formats for numbers.
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.
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?
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.
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
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?
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!
Love your work!
But the underlines under measures in a text box cannot be turned off. That is why I almost always use buttons for this scenario.
how does one get rid of the blue line in the text box ?
Great tricks paTrick ;)
Thanks - great tip
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.
Did you ever get this resolved?
@@luisona9467 No, but we recently moved our cube to the cloud, so I think I will give it another shot.
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)
Great video!
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.
nice one dude!
The thing I don't get it. It's why when I create my measure the text box QA don't recognize it. =/.
LOVE This!💙💙💙
You only have cool videos, tnx!
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"
Awesome !
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.)
Strangely, I've never used anything else but textboxes in this regard.
That's amazing.
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
thank you if you helped my case patrick
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...
Hello Benjiman, thanks for the comment. I just tested this with RLS in the report and it worked. Now with OLS it does not work. Can you please elaborate on your scenario where it does not work? Really interested in reproducing.
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 (ua-cam.com/video/sbg1KpoOBds/v-deo.html).
Datatype of .pbix
late to the party, sorry 😉