CUSTOM Dynamic text boxes in Power BI

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:

[siyabongamyeza]

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

[vivekkoli]

This is really cool, definitely helpful. Thank you 🙏

[bradj]

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

[jefferynguyen]

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

[cpa]

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

[PowerBIPark]

Strong content Christine! keep it up 🥳🥳

[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?

[joelluis]

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 !

[didiermaignan]

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

[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

[martinmakar]

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!

[krunalkp]

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

[brendamacarenavelasque]

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.

[tinaflemons]

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

[Oopsiedaisy]

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

[TimingIsEverything]

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(), "<no change>",
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(), "<no change>",
BLANK() )

with _HC%ChangeYoY_USA =

_HC%ChangeYoY_USA = DIVIDE( [_HC USA], [_HC USA PY] ) - 1

where _HC USA =
VAR MinDate = MIN( )
VAR MaxDate = MAX( Calendar_FY_To2025[End of Month] )
VAR Headcount =
CALCULATE(
COUNTROWS( Actives_Mthly ),
FILTER(
VALUES( ),
= MaxDate
),
FILTER( 'Home Country DIM',
'Home Country DIM'[Global_Label] = "USA" )
)
RETURN
Headcount

Can someone help?