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).
@NateHerring12 жыл бұрын
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.
@andyparkerson2 жыл бұрын
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.
@GuyInACube2 жыл бұрын
Yeah the card has some limitations, but this make it so easy.
@TheQuang6692 жыл бұрын
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.
@tdzinkdroid2 жыл бұрын
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.
@RodrigoGosling2 жыл бұрын
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.
@natoetire4532 жыл бұрын
Was going to ask around this. How do you combine static and dynamic text. Do you just include the static bit in the formula?
@eth67062 жыл бұрын
Finally something I've been doing before Patrick has
@fraggle2002 жыл бұрын
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.
@tomduffhues6222 жыл бұрын
You are bringing the party! Thanks Patrick
@saifali41072 жыл бұрын
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. 👍🏻
@buddhigupta35572 жыл бұрын
Yes, I have used text box with measures while converting reports from Cognos to Power BI to give similar parameters display.
@raymondmcgaw44782 жыл бұрын
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.
@iamthemoss Жыл бұрын
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
@im1rkm2 жыл бұрын
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?
@sambull33142 жыл бұрын
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..
@munishghai742 жыл бұрын
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.
@michalbicki32212 жыл бұрын
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?
@renatonappo3630 Жыл бұрын
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.
@jakeonash2 жыл бұрын
You Rock, Patrick. Thanks for sharing
@saisatya55252 жыл бұрын
As always you are awesome👍
@GuyInACube2 жыл бұрын
Thanks for watching
@sgk19662 жыл бұрын
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.
@wygoda1232 жыл бұрын
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.
@chriswall47952 жыл бұрын
This is great, I’ve been doing something similar in Excel for years ... we’ll need to rework quite a few of our PBIXs!
@robertkersey88432 жыл бұрын
For titles and visuals I prefer using the format dax function where you can have dynamic titles as a measure
@evnpresson72582 жыл бұрын
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
@pbible2 жыл бұрын
You rock Patrick!
@reymarenterprise2262 жыл бұрын
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.
@sqlservertutorialin3minute4855 күн бұрын
Hi, can we copy the content from the textbox? I tried but couldn't find a way. Thanks for the help!
@alexjose50462 жыл бұрын
Awesome !
@cyrilzyriacjoseph19612 жыл бұрын
Is there any way to remove the underline below the dynamic text?
@picssuxxx2 жыл бұрын
Amazing !! Microstrategy do the same but you just need to drag and drop de measure into the text box. Easy like a sunday morning ;)
@etherlords882 жыл бұрын
What it takes to get to the point directly? (2:28)
@markhenderson37712 жыл бұрын
The music/sound in the background makes is distracting and it's difficult to take in your content, which is great by the way.
@JerryTiberlake2 жыл бұрын
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
@WolFX_FPS2 жыл бұрын
Love your work!
@Nazeerul_Hazard2 жыл бұрын
Cool - you are always on time for the party :)
@cryptoman27362 жыл бұрын
BUT you can't get rid of the line below the text which is soooo annoying!
@manendraguntamukkala1765 Жыл бұрын
Can we have a custom color like Red for negative numbers and Green for Positive numbers?
@Whitepawprint2 жыл бұрын
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!
@yveshermann2 жыл бұрын
The videos are great....I still find hard to watch to finish them...
@fjalarsigurdarson48622 жыл бұрын
Thanks - great tip
@manojjadhav40934 ай бұрын
Hey Man. March 2024 The Copy Data table Option is disable is another option to Copy Data Table
@kennethstephani6922 жыл бұрын
Great video!
@davidmorales87933 ай бұрын
What if I want to show the text box only when the user clicks on a shape from a shape map?
@visheshjjain2 жыл бұрын
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?
@kishoreyc2 жыл бұрын
you never disappoint me.
@Anthony_Lecoq2 жыл бұрын
Great tricks paTrick ;)
@parthshah7422 Жыл бұрын
Hi , i am not able to find fx function in new power bi update in column colours under visual effects
@garyvanc2 жыл бұрын
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.
@NateHerring12 жыл бұрын
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.
@MrJamesbotes Жыл бұрын
how does one get rid of the blue line in the text box ?
@powerbiguy3262 жыл бұрын
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 .
@talihiggins59472 жыл бұрын
LOVE This!💙💙💙
@andrewdutch48432 жыл бұрын
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??
@theA12d12 жыл бұрын
nice one dude!
@garyalioto2197 Жыл бұрын
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?
@DeepakKumar-qo9nj2 жыл бұрын
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
@jhazielpetersen7612 жыл бұрын
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
@scottwoehl20692 жыл бұрын
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.
@jacksteinwedel75442 жыл бұрын
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?
@johnabram41592 жыл бұрын
Great! But, that underline is nagging. Couldn't find a way get rid of that. Any ideas?
@SpaceMusicOutofWorld Жыл бұрын
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.
@anishajoseph51343 ай бұрын
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!!
@somnathchatterjee21922 жыл бұрын
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.
@chandrakaanthr2 жыл бұрын
Hey Patrick. Is there a way to use shape maps as slicers in Power BI ??
@kristofferwestbi2 жыл бұрын
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 ;)
@iLikeNachooooz Жыл бұрын
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?
@rrve2 жыл бұрын
But the underlines under measures in a text box cannot be turned off. That is why I almost always use buttons for this scenario.
@qayyumkadri21382 жыл бұрын
That's amazing.
@samiraslan97352 жыл бұрын
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!
@hvbdc902 жыл бұрын
You only have cool videos, tnx!
@Iamcorky122 жыл бұрын
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.
@xavierrodriguez5784 Жыл бұрын
The thing I don't get it. It's why when I create my measure the text box QA don't recognize it. =/.
@Haaknes2 жыл бұрын
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.
@luisona94672 жыл бұрын
Did you ever get this resolved?
@Haaknes2 жыл бұрын
@@luisona9467 No, but we recently moved our cube to the cloud, so I think I will give it another shot.
@danb69082 жыл бұрын
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)
@nmbambo2 жыл бұрын
Strangely, I've never used anything else but textboxes in this regard.
@jennifermaines51242 жыл бұрын
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"
@talkdatainsight33772 жыл бұрын
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
@talkdatainsight33772 жыл бұрын
thank you if you helped my case patrick
@MrJupiterftw2 жыл бұрын
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.)
@benouboy12 жыл бұрын
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...
@GuyInACube2 жыл бұрын
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.
@dilipkumar-ck1nc2 жыл бұрын
Datatype of .pbix
@HachiAdachi2 жыл бұрын
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).