Introduction

Effective titles are key to engaging reports, providing context and clarity to your audience. Enhance your Power BI reports with dynamic visual titles that adjust based on filter and slicer selections. This guide also serves as a valuable resource for those preparing for the Microsoft PL-300 exam, as dynamic titles are a key component of effective report design. In this hands-on Power BI tutorial, you'll learn how to create a dynamic visual titles like the one shown below:

0:00
/0:15

📂 Data

We have already loaded data from an Excel file into Power BI Desktop. There is the following table:

student: Contains student information.

🎯 Goal

Our goal is to create a visual where the title changes dynamically based on the filtered enrollment year. For example, when we filter by a specific year, the title should display the selected year.

1) Create Visual

Start by creating a bar chart that shows the number of students per major. Choose the title Number of students per major.

2) Create Slicer

Next, create a slicer for the column enrollment_year with single value selection. Select a sample value for the slicer for example 2022.

As you see the values of the bar chart change, but the title remains static.

3) Implement Measure

In order to create a dynamic title, we'll use the DAX function SELECTEDVALUE. Create a new measure called Total Students (Removing Birth Year) and enter the following DAX code:

You can view this post with the tier: Academy Membership

Join academy now to read the post and get access to the full library of premium posts for academy members only.

Join Academy Already have an account? Sign In