Concept Breakdown
DAX measures can return text strings that dynamically change based on user selections and visual context within a Power BI report. This allows for personalized labels on card visuals (e.g., showing the name of a selected item) and rich, context-aware tooltips for charts. Key functions include `SELECTEDVALUE` for retrieving a single selected value, `CONCATENATEX` for iterating over a table and concatenating values into a single string (often with formatting and conditional logic), and `RELATED` or `RELATEDTABLE` for accessing data from related tables within the iteration.
What You Will Learn
Understand when to use VALUES, CONCATENATEX, SELECTEDVALUE, RELATED, SUMMARIZE in a Power BI model.
Practice the concept inside a real PBIX report rather than only reading syntax.
Complete a intermediate-level task and verify the result with a hidden answer check.
Practice in Power BI
The starter PBIX link has not been attached yet. The student workflow is ready for the admin to connect the file.
Download and unzip the provided 'Music Tours - Dynamic Labels.pbix' file and open it in Power BI Desktop.
Create a measure named `Selected Artist Name` that returns the name of the currently selected artist.
Create a card visual at the top of both the 'Albums' and 'Tours' pages and assign the `Selected Artist Name` measure to them. Format the cards to align with existing text boxes.
Create a measure named `Album Tooltip Details` that lists album titles along with their year of release, sorted by release date, with each album on a new line (use `UNICHAR(10)`).
Assign the `Album Tooltip Details` measure to the tooltips of the pie chart on the 'Albums' page.
Create a measure named `Track Tooltip Details` that lists track names, sorted by the `Track order` column. Add a gold star emoji (Windows key + '.') next to tracks which reached number 1 in the US Billboard Hot 100 chart.
Assign the `Track Tooltip Details` measure to the tooltips of the column chart on the 'Albums' page.
Create a measure named `Tour Tooltip Details` that lists show dates and venues, sorted by show date and separated by a new line. The `RELATED` function may be useful here.
Assign the `Tour Tooltip Details` measure to the tooltips of the column chart on the 'Tours' page.
Create a measure named `Country Show Counts Tooltip` that lists countries and the count of shows performed in them. Separate each country with a new line, sort them alphabetically, and ensure only countries with actual shows are included. Use the existing `Count Shows` measure if available.
Assign the `Country Show Counts Tooltip` measure to the tooltips of the pie chart on the 'Tours' sheet.
Save and close the report.
Starter DAX
-- To create a new measure, right-click on your table in the Fields pane and select 'New measure'.
-- Replace 'Your Measure Name' with a descriptive name and the 'BLANK()' with your DAX formula.
Your Measure Name =
BLANK()Expected Outcome
A Power BI report where:
- Card visuals on 'Albums' and 'Tours' pages dynamically display the name of the artist selected from the 'Menu' page.
- The pie chart on the 'Albums' page shows a tooltip with a formatted list of albums and their release years for the selected artist.
- The column chart on the 'Albums' page shows a tooltip with a formatted list of tracks, including a gold star emoji next to US #1 hits, for the selected artist.
- The column chart on the 'Tours' page shows a tooltip with a formatted list of show dates and venues for the selected artist.
- The pie chart on the 'Tours' page shows a tooltip with an alphabetically sorted list of countries and their respective show counts for the selected artist, only including countries with shows.