QT#66 - Integrate Measures Into the Standard Power BI Text Box to Create Dynamic Titles

In this video you'll learn how simple it is to integrate measures into the standard Power BI text box to create dynamically updated text in your report pages.

It's super easy to embed your measure into the text box, allowing you to integrate them into descriptions and narratives. Then, like in all Power BI visulisations, the values will change depending on the filter context applied to the visual.

This approach is great for report page titles or stand lone text boxes where you want to add a dynamic summary of the information displayed. This could be useful if your report page is part of a report or even embedded into had PowerPoint presentation. See the link below to my video on embedding Power BI into Power Point.

----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Introduction
00:40 - Adding Dynamic Value to the Text Box
02:05 - Modifying formatting in Text Box
03:00 - Adding a More Dynamic Values
04:45 - Formatting Number of Decimal Places Displayed
06:00 - Summary of Dynamic Text

-----------------------------------------------------
🎥 Related Videos
-----------------------------------------------------
QT#64 - How to Embed Power BI Reports into PowerPoint + Create Monthly Maintenance Report Template

-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!

👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that really do help you, your boss, and your peers make better decisions!

-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for my YouTube videos:

👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).

[Whitepawprint]

Hi Jason, great video! I'm hoping you might be able to shed some light on a strange issue I'm having with this feature.

I use the dynamic text regularly, it's one of my favourite features to put in a report, so I'm familiar with the tool. HOWEVER, a big issue I keep encountering is that semi-regularly (although I think this seems to mostly happen when I start building new reports?) is the Q&A tool that asks "how would you calculate this value?" absolutely REFUSES to find my measures, no matter what I try, or what I name them.

When this issue happens, I've tried everything. Giving the measures really unique/distinctive names that Power BI can't confuse with anything else, typing in the entire location e.g 'table'[measure], and just about anything else under the sun.

Occasionally I can trick it if I find something it can reference, change the name to that thing, connect to it, and then change the name back. But it doesn't always work.

This is the absolute bane of my life, and is massively frustrating as (as far as I can tell) there's no reason it shouldn't be able to find it... aside from the tool just being broken/poorly optimised. I have also had this issue mysteriously fix itself on some reports, where after WEEKS of not picking up on a measure, one day I will check back on the same unchanged measure, and it will find it no problem, and generally works fine for all my measures from that point on.

I've not been able to find much help or information about this elsewhere online... If you (or anyone else) has any ideas or suggestions, I'm all ears!

Many thanks!

[alexrosen]

Well explained demo for a very useful topic in Power BI.

[ffvolhs]

Hi Jason, Great videos so far. I have been struggling with formatting a figure in my text box (i.e $8, 783, 012, 029.32 to show $8.78bn in the text box). I checked youtube and found your video. I thought to ask you if you can help. Thank you

[ajojoy]

Feature is not working for me when the PBIX file has Direct Query dataset

[gheyman]

I get a message that says "Adding dynamic values isn't supported in this application" any other suggestions for a workaround?

[manendraguntamukkala]

How can we display the Red colour for negative values and Green for Positive values when we use these dynamic values using the Values option in the Text box?

[BryanMcSorley]

Hi Jason, great video. I noticed a tab visual around the 4:20 mark in the video. The visual had a "BL by Dept matrix" as the title. Can you share the name of this visual and if it is available in the visual catalogue?