CUSTOM Dynamic text boxes in Power BI

No video

CUSTOM Dynamic text boxes in Power BI

Рет қаралды 44,597

Күн бұрын

Text boxes are a nice way to give your audience an overview of the main takeaways from your report. You can enhance them by making their outputs dynamic and affected by the viewer's interactions with your other visuals.
If you’re looking for a practice activity in this topic with sample data, there is a Power BI Workout Wednesday post here:
workout-wednes...

Пікірлер: 48

@siyabongamyeza5315 6 ай бұрын

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

@vivekkoli4479 8 ай бұрын

This is really cool, definitely helpful. Thank you 🙏

@bradj229 8 ай бұрын

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

@bi-ome 8 ай бұрын

Thank you, that is very nice to hear!

@stevensun-dc2td 13 күн бұрын

Thank you very much!

@user-iz6ju9ft6e 3 ай бұрын

so cool, very helpful, thanks

@mrfish4572 8 ай бұрын

Super helpful

@cpa10302 4 ай бұрын

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 4 ай бұрын

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

@MultiTin0 4 ай бұрын

Thank you so much!

@PowerBIPark Жыл бұрын

Strong content Christine! keep it up 🥳🥳

@bi-ome Жыл бұрын

Thanks! You too :)

@RedCloudServices 6 ай бұрын

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 6 ай бұрын

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. 🙂

@didiermaignan76400 7 ай бұрын

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 7 ай бұрын

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. 😊

@jefferynguyen5177 Жыл бұрын

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

@JenMayB 2 ай бұрын

What font are you using? I love it!

@bi-ome 2 ай бұрын

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

@JenMayB 2 ай бұрын

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

@AghaOwais 3 ай бұрын

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 3 ай бұрын

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.

@brendamacarenavelasque9567 5 ай бұрын

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 5 ай бұрын

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 5 ай бұрын

@@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... 😮‍💨

@krunalkp1032 3 ай бұрын

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

@bi-ome 3 ай бұрын

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

@ChauBui-tt6fe Жыл бұрын

Thanks so much 🙏🙏

@martinmakar9559 7 ай бұрын

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 7 ай бұрын

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 7 ай бұрын

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 7 ай бұрын

@@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 7 ай бұрын

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

@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

@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. 😊

@Oopsiedaisy861 5 ай бұрын

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

@bi-ome 5 ай бұрын

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

@TimingIsEverything13 5 ай бұрын

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 5 ай бұрын

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 5 ай бұрын

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

@bi-ome 5 ай бұрын

@@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 4 ай бұрын

@@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 4 ай бұрын

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.