CUSTOM Dynamic text boxes in Power BI

[@siyabongamyeza5315]

your tone is exceptional. you make it sound easy. Thanks. Definitely subscribing

[@bradj229]

First time visiting your channel. I like how you clearly explain what you're demo-ing. I subscribed. Thanks :)

[@bi-ome]

Thank you, that is very nice to hear!

[@vivekkoli4479]

This is really cool, definitely helpful. Thank you 🙏

[@RedCloudServices]

Christine great channel ❤ I simply have a table with an id, title and description column. When an id is selected as my page filter I want a box to dynamically display the correct title and description. I tried this with a card and it does not wrap the text. Should i just use a table visual or text box to display the filtered description and wrap the text?

[@bi-ome]

Sure, I would use a text box personally. If you use a table you'll have to pfaff around trying to make all the bits transparent to make it look nice. For getting simple text labels when a filter is applied, I usually just use MIN() or MAX() on the field, potentially wrap it in CALCULATE() if it uses a relationship. Basically all you're doing is getting the scalar value, if there's only ever one value when it's filtered it doesn't really matter if you get the min or the max, you just need to use some function to get the singular value out. 🙂

[@Mandeep-s8l]

love your content ...where can i access sales dashboard page tutorial??

[@bi-ome]

Thanks!! The original is here, I have it delisted because I keep meaning to make an updated one. It’s high up there on my list… kzbin.info/www/bejne/lZjYgnuQj9CJaLc

[@cpa10302]

Appreciate the video, it helped me alot! Also, I hit the subscribe button as soon as you said "janky". I've been trying to bring this word back for years haha

[@bi-ome]

LOL it is a great word, I use it all the time 😄

[@mrfish4572]

Super helpful

[@krunalkp1032]

There is an automatic underline under the dynamic value any way to remove it ? Thanks

[@bi-ome]

It only shows up in the desktop version, when you publish it disappears - so web viewers won't see it :)

[@AghaOwais]

Could you please tell me how can I apply font colour changes on up 20%. Like for up 20% it should be shown green and for down % it should be shown in red. Thanks

[@bi-ome]

The text boxes won't accept conditional formatting rules, so the only way I know of to change color of things is to use a unichar character that already has color. It's not like the table visual where you can pull the color code from a measure.

[@JenMayB]

What font are you using? I love it!

[@bi-ome]

Thanks! Always Segoe UI haha. Semibold or normal, never full bold. This feels like a twist on a coffee commercial now…

[@JenMayB]

@@bi-ome thanks! For some reason your segoe looks better than mine. Ha!

[@PowerBIPark]

Strong content Christine! keep it up 🥳🥳

[@bi-ome]

Thanks! You too :)

[@martinmakar9559]

Hi, thank you for making this video! question...I created a new measure to use as dynamic text but I cannot get it show up. Q&A doesn't see it, or find it. I tried almost everything i can think of like adding synonyms, renaming, creating new measure, making it text or decimal, nothing seems to work. also tried creating a custom column and seeing if it finds it that way, but nothing has worked. any ideas? have you had this experience? thank you in advance!

[@bi-ome]

I would try setting the name of the measure to be something very unique, then putting that exact name into the box and giving it about 30 seconds or so to show up. Sometimes it takes a REALLY long time and you think it's not finding it but it really just takes longer than you expect? I've not had it not show up at all.

[@martinmakar9559]

thank you so much for the quick reply!! I just tested on an older backup file I had and it worked after creating the new measure there. I think I may have another issue unrelated to the measures or Q&A. maybe a corrupt file or something. it seems like nothing new is being recognized. because all my previous measures work. if you have any thoughts that could help, they would be appreciated. otherwise, thank you for the videos. they are very helpful. @@bi-ome

[@bi-ome]

@@martinmakar9559 Sure, you might try running a refresh if you haven't, and clearing the cache in settings... that sometimes shakes things loose. If you store the PBIX in a OneDrive-synced library, you get full version history and can revert/look at versions much more easily (I have a video on that somewhere too!). That has saved my bacon more than once. 😄

[@martinmakar9559]

Smart!! thank you. I will try this clearing cache@@bi-ome

[@micheldeacha3499]

i know this is old, but if it helps you or other people. the solution i found is disabling tables you won't use in the Q&A. apparently it can't handle that many tables. so just don't include tables you won't use in the Q&A. Go to Synonyms and uncheck the tables you won't be using for your dynamic values

[@brendamacarenavelasque9567]

Hello. I have a desktop version from January 2024 installed, I can't choose +value or review (are not there) in the text box, does it happen to anyone else? I can´t find the solution, I need help. Thanks.

[@bi-ome]

Hmm, this has been in the product for at least a year, probably a lot longer than that - and I don't think it's something you can turn off, so I'm not sure what is going on. You do have your cursor active in the box, right? 🤨

[@brendamacarenavelasque9567]

@@bi-ome Yes, it's active and I can also edit the text format (color, size...) but I can't add any measurements to it. It is not dynamic... 😮‍💨

[@walterstevens8676]

I have the same problem. When I insert a text box and click on the "+" to add a measure, the app doesn't find a measure no matter what I try. Super frustrating.

[@brendamacarenavelasque9567]

@@walterstevens8676 A colleague told me that this function is only available in the cloud version of Power BI, so they removed it from the desktop version updates. However, I found another way to do something similar. Now, I first create a measure to concatenate text with the other measure I need, and then I set it as a dynamic title for a card chart to display only the title. It works well. Good luck.

[@didiermaignan76400]

You did a great job, considering how documentation is weak. I also wanted more text calculation, and discovered that it was not so simple and not documented at all, tell me is I am wrong and missed something. for example how to find the text for a titre in FR language in a glossary . After long exploration, Valeur Titre(Entité) with CodeLangue FR is working fine in my case

[@bi-ome]

Thanks, yes, I have a tendency to use MAX() or MIN() to get a scalar text value from the 1 side of a 1:many relationship, because there will only ever be one value - not sure if that's the "official" way but it works. 😊

[@hokasphokas]

so cool, very helpful, thanks

[@jefferynguyen5177]

Liked and subscribed. Very nice and useful content. Keep up the good work!

[@joelluis4938]

Hi ! Great Video .I have a question ..I have a column with 2 string values because my table is a merge of 2 tables and I have 1 column which shows a date to know where those tables come from.. For ex: One table comes from 'Jan 15' and second table comes From 'Feb 15' so half of my table shows 'Jan 15' and the other part shows 'Feb 15'' in that column. I would like to create 2 text box to change dynamic as you did to show one specific date witch each formula. I was expecting to see how did you select your ''2002'' in your text box but you didn't show it. Could you please tell me which dax formula did you use to select one value ? I think this would work for me too !

[@bi-ome]

Sure, you can filter your measures using CALCULATE(), there's an example in the documentation here at the bottom of the page where they are filtering their measure on the color 'Blue' - the same should work for you (though you might consider using a date table for dates if you aren't already!): learn.microsoft.com/en-us/dax/calculate-function-dax

[@MultiTin0]

Thank you so much!

[@tinaflemons263]

Great video. Do you provide copies of the pbix files?

[@bi-ome]

Thanks! I put most of the tutorials into a single pbix in GitHub. The sales dashboard tab in it has a dynamic text box - it’s very similar to the one in the video: github.com/chpayton/BI-Files

[@tinaflemons4022]

Thank you, your teaching style is wonderful. It is like chatting with a friend.

[@bi-ome]

@@tinaflemons4022 I’m just a fellow BI dev, sharing things I pick up - so that’s basically true. 😊

[@ubaid1231]

How i remove underlines ?

[@bi-ome]

The underlines are only visible in the desktop editor - when you publish, your users don't see them. :)

[@ChauBui-tt6fe]

Thanks so much 🙏🙏

[@Oopsiedaisy861]

Cannot stand how Microsoft chose to implement this in Power BI. Incomprehensibly idiotic for no reason.

[@bi-ome]

In the scheme of things in the Power Platform, this doesn’t even register on my gripe list. But I hear you! 😂

[@TimingIsEverything13]

Great video! I need some help with using measures that contain filtering in the logic. For example, I have formatted my measure for % change you to the following, but its not picking it up. v1: This one is working. Text_HC%ChangeYoY_Global = VAR PercentChange = [_HC%ChangeYoY_Global] RETURN SWITCH( True (), PercentChange >= 0, "increased by " & CONCATENATE( ROUND( PercentChange * 100, 1), "%"), PercentChange < 0, "decreased by " & CONCATENATE( ROUND ( PercentChange * -100, 1), "%"), PercentChange = BLANK(), "", BLANK() ) v2: This one is not (and unfortunately the rest of my measures have filtering logic) - It is the same base measure for Global except with the filtering of the a DIM table for home country = USA Text_HC%ChangeYoY_USA = VAR PercentChange = [_HC%ChangeYoY_USA] RETURN SWITCH( True (), PercentChange >= 0, "increased by " & CONCATENATE( ROUND( PercentChange * 100, 1), "%"), PercentChange < 0, "decreased by " & CONCATENATE( ROUND ( PercentChange * -100, 1), "%"), PercentChange = BLANK(), "", BLANK() ) with _HC%ChangeYoY_USA = _HC%ChangeYoY_USA = DIVIDE( [_HC USA], [_HC USA PY] ) - 1 where _HC USA = VAR MinDate = MIN( Calendar_FY_To2025[Fiscal_BOP] ) VAR MaxDate = MAX( Calendar_FY_To2025[End of Month] ) VAR Headcount = CALCULATE( COUNTROWS( Actives_Mthly ), FILTER( VALUES( Actives_Mthly[File.Capture.Date] ), Actives_Mthly[File.Capture.Date] = MaxDate ), FILTER( 'Home Country DIM', 'Home Country DIM'[Global_Label] = "USA" ) ) RETURN Headcount Can someone help?

[@bi-ome]

When you say it’s not picking it up, do you mean when you search for the measure name it doesn’t appear, or the value doesn’t show when it’s selected? If it’s the latter, does it have a value when you put it in a table or card visual?

[@TimingIsEverything13]

@@bi-ome Correct, it does not appear. When I drop it in a card it populates the value correctly.

[@bi-ome]

@@TimingIsEverything13 Just for the heck of it I'd try renaming the measure that's not working to something totally unique - like Sprinkle Cupcake Cookies, and seeing if that works as a troubleshooting step. It may be if the two measure names only a few characters different, it struggles? Or that's my hypothesis anyway

[@TimingIsEverything13]

@@bi-ome I keep getting the red lines saying "We're not sure what you mean. Try another term or add this one." I've tried the Teach Q&A but it never accepts my submissions. If there is way I can set up the calculation for each measure reference, I would, but I keep hitting a wall.

[@bi-ome]

I'm not sure, sorry - if it's not resolving even when you paste the exact name, and renaming it doesn't help, I'm not sure what will. You could try pasting the formula into a new measure just in case that resets something? I'm out of ideas.

[@stevensun-dc2td]

Thank you very much!