2023 Week 44 | Power BI: Dynamic Text Boxes

Power BI, Workout Wednesday / By

Introduction

For this week’s challenge, we will be creating dynamic text boxes to introduce our visuals and tell a story around our data. This is differentiated from the “smart narrative” visual in that we will customize the text and measures that we display to create our own narrative.

In the example below, you’ll notice that the numbers and text in the box changes according to which slicers are selected. We can even use UNICHAR() for symbols and emojis in the box!

Requirements

  1. Get data from the GitHub link below and create any table relationships you plan on using in your measures
  2. Create the measures that will be inserted into the text box. No need to match the example measures, make your own!
    1. Want to use symbols or emojis in your measures? Here’s a reference to codes to use with UNICHAR().
  3. Add a text box to your report page.
  4. Insert your measures inside the text box using the “+value” button in the editor. You can add static text around the measures to create a paragraph.
    1. Hint: Start typing the name of your measure in the “ask a question” box that pops up when selecting “+value”; your measure may take a few seconds to load in the dropdown (using the full exact name of the measure helps).
  5. Bold or color your measures in the text to make them stand out!
  6. Add a table or chart to your page to visualize the data you’re referencing in the text box.

Dataset

Download the data from GitHub – we are using the Microsoft AdventureWorks dataset, specifically the Sales, Sales Order, Product, and Date tabs of the Excel file. The relationships we need in the model will be auto-created for all but the Date[DateKey] -> Sales[OrderDateKey] relationship (assuming you have auto-creation of relationships enabled).

Share

After you finish your workout, share on Twitter using the hashtags #WOW2023 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.

Solution

Solution File available for download via Data Stories Gallery

Scroll to Top