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 ==>	Relatively easy
Subject ==>	Power BI training

Use the SELECTEDVALUE and CONCATENATEX functions to create dynamic labels for visual in Power BI Desktop

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 Tallest Buildings Dynamic Labels.pbix file in the folder shown above. On Page 1 you'll find a slicer which allows you to select a single country, and a chart showing the buildings for the selected country.

Use the SELECTEDVALUE function to create a measure which shows the name of the selected country. Assign this measure to the title of the chart visual.

A slicer and chart visual with a dynamic title using a DAX measure in Power BI Desktop

Make sure that you have only one country selected at this point.

Edit the measure to add the phrase Tallest buildings in before the name of the country.

A DAX measure creating a dynamic title for a chart visual in Power BI Desktop

Your chart title should now look like this.

Edit the measure again to include the count of buildings after the name of the country.

You can use the existing Count of Buildings measure to help with this part.

Edit the SELECTEDVALUE function so that it returns the phrase multiple countries if you select more than one country in the slicer.

A dynamic title for a Power BI chart visual using a DAX measure.

You can hold CTRL and click to select multiple items in the slicer.

On Page 2 you'll find a chart showing the average height of buildings in different countries.

Create a measure using the CONCATENATEX function which lists the building names, separating each with a new line. Assign this measure to the tooltips of the chart.