This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	DAX (59 exercises)
Topic ==>	The VALUES function (7 exercises)
Level ==>	Average difficulty
Subject ==>	Power BI training

Use DAX measures to create dynamic labels for visuals in a Power BI Desktop report.

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

Open the Music Tours - Dynamic Labels.pbix file in the folder shown above. You can use the chart on the Menu sheet to select an artist, then hold CTRL and click a button to see either the artist's album details or tour details.

A chart visual with dillthrough buttons in Power BI Desktop

When the report is published, the user can click the button without holding CTRL.

Create a measure which returns the name of the selected artist. Create a card visual at the top of the Albums and Tours pages and assign the measure to each.

A card visual showing the result of a DAX measure in Power BI Desktop

Formatting the card to align it with the text box is probably the most challenging part of this!

Create a measure which lists album titles along with their year of release, sorted in order of release date, separating each album with a new line character. Assign this measure to the tooltips of the pie chart on the Albums page.

A dynamic tooltip in a pie chart visual in Power BI Desktop

You can use UNICHAR(10) to insert a new line character.

Create a measure which lists track names, sorting them by the Track order column. Add a gold star emoji next to tracks which reached number 1 in the US Billboard Hot 100 chart. Assign this measure to the tooltips of the column chart on the Albums page.

A Power BI chart visual using a DAX measure to create a dynamic tooltip.

You can display the emoji picker by holding the Windows key and pressing .

Create a measure which lists show dates and venues, sorted in order of show date and separating each with a new line. Assign this measure to the tooltips of the column chart on the Tours page.

A dynamic tooltip on a chart visual in Power BI Desktop showing the value of a DAX measure

You might find the RELATED function useful for this example.

Create a measure which lists countries and the count of shows performed in them. Separate each country with a new line and sort them alphabetically. Make sure to only include countries which had shows performed in them. Assign this measure to the tooltips of the pie chart on the Tours sheet.