CUSTOM Dynamic text boxes in Power BI
Вставка
- Опубліковано 16 кві 2023
- 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-wednesday.com/2023-we... - Наука та технологія
your tone is exceptional. you make it sound easy. Thanks. Definitely subscribing
This is really cool, definitely helpful. Thank you 🙏
First time visiting your channel. I like how you clearly explain what you're demo-ing. I subscribed. Thanks :)
Thank you, that is very nice to hear!
Thank you so much!
so cool, very helpful, thanks
Liked and subscribed. Very nice and useful content. Keep up the good work!
Super helpful
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
LOL it is a great word, I use it all the time 😄
Strong content Christine! keep it up 🥳🥳
Thanks! You too :)
Thanks so much 🙏🙏
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?
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. 🙂
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 !
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
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
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.
There is an automatic underline under the dynamic value any way to remove it ?
Thanks
It only shows up in the desktop version, when you publish it disappears - so web viewers won't see it :)
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.
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? 🤨
@@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... 😮💨
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
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. 😊
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!
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.
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
@@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. 😄
Smart!! thank you. I will try this clearing cache@@bi-ome
What font are you using? I love it!
Thanks! Always Segoe UI haha. Semibold or normal, never full bold. This feels like a twist on a coffee commercial now…
@@bi-ome thanks! For some reason your segoe looks better than mine. Ha!
Great video. Do you provide copies of the pbix files?
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
Thank you, your teaching style is wonderful. It is like chatting with a friend.
@@tinaflemons4022 I’m just a fellow BI dev, sharing things I pick up - so that’s basically true. 😊
Cannot stand how Microsoft chose to implement this in Power BI. Incomprehensibly idiotic for no reason.
In the scheme of things in the Power Platform, this doesn’t even register on my gripe list. But I hear you! 😂
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?
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?
@@bi-ome Correct, it does not appear. When I drop it in a card it populates the value correctly.
@@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
@@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.
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.