Dynamic Titles with DAX

Step 1: Understanding the Core DAX Function: SELECTEDVALUE

To get the value a user picks from a slicer, we need a function that can read that selection from the filter context. The primary function for this job is SELECTEDVALUE. It's designed to return a value only when a single, unambiguous choice has been made.

Let's start with the theory behind this essential function.

As you read, SELECTEDVALUE is essentially a shortcut for IF(HASONEVALUE(...), VALUES(...), AlternateResult). This makes it perfect for our initial goal: capturing a single slicer selection.

Step 2: Creating and Applying a Basic Dynamic Title

Now that you understand the theory, let's put it into practice. We'll create our first dynamic title measure and apply it to a visual.

The process involves two key steps:

1. Writing a DAX measure that combines static text (like "Sales for ") with the dynamic value from SELECTEDVALUE.
2. Connecting this measure to the visual's title property using the conditional formatting (fx) button.

The following video provides a complete walkthrough of this process, including how to handle a common pitfall where the selected value is a number instead of text.

To apply the measure, you'll need to find the conditional formatting button for the title. It's located in the Format your visual pane under General > Title > Text.

Step 3: Handling Multiple Selections and No Selections

Our basic measure works great for a single selection, but what happens if a user selects multiple items, or clears the slicer entirely? In both cases, SELECTEDVALUE returns a blank, and our title will look incomplete.

A professional report must handle these scenarios gracefully.

• No Selection: The title should display a default message, like "Sales for All Categories".
• Multiple Selections: The title should list the selected items, for example, "Sales for Laptops, Desktops".

To achieve this, we need to introduce two more functions:

• CONCATENATEX: This iterator function builds a string by joining together the values from a table (in our case, the list of selected categories).
• ISFILTERED: This function checks if a column is currently being filtered, which tells us if the user has made any selection in the slicer.

The next segment of the video you started watching explains exactly how to enhance our measure to handle these situations.

By combining these functions with IF logic and variables, you can create a single, powerful measure that handles all user interactions correctly.

Your Turn: Create a Dynamic Title

Now it's time to apply what you've learned to our sales report. Your task is to create a dynamic title for the main line chart showing sales over time.

1. Create a Slicer: If you don't already have one, add a slicer to your report page for the Product[Category] column.

2. Write the DAX Measure: Create a new measure named Dynamic Chart Title. This measure should return:

   • "Total Sales for [Selected Category]" if one category is selected.
   • "Total Sales for All Categories" if no categories are selected.
   • "Total Sales for Multiple Categories" if more than one category is selected. (For an extra challenge, try using CONCATENATEX to list them!)

   Hint: You can structure your measure with variables and an IF or SWITCH statement.

   Dynamic Chart Title = 
   VAR SelectedCount = DISTINCTCOUNT('Product'[Category])
   VAR SingleSelection = SELECTEDVALUE('Product'[Category])
   RETURN
       SWITCH(TRUE(),
           SelectedCount = 1, "Total Sales for " & SingleSelection,
           ISFILTERED('Product'[Category]), "Total Sales for Multiple Categories",
           "Total Sales for All Categories"
       )
   

3. Apply the Measure:

   • Select your line chart.
   • Go to Format your visual > General > Title.
   • Click the fx button for the Text property.
   • In the dialog, set Format style to "Field value" and select your [Dynamic Chart Title] measure.
   • Click OK.

Test your work by selecting one category, multiple categories (by holding Ctrl and clicking), and clearing the slicer. The title of your chart should update perfectly with each interaction.

Conclusion

Excellent work! You've just added a feature that significantly improves the user experience of your report. Dynamic titles provide immediate, clear context, which is a hallmark of a well-designed and professional dashboard.

Key Takeaways:

• SELECTEDVALUE is the primary function for capturing a single user selection from a slicer.
• For a robust title, you must handle three scenarios: single selection, no selection, and multiple selections.
• CONCATENATEX is used to create a text list from multiple selected items.
• ISFILTERED or counting distinct values helps you determine which scenario is active.
• The dynamic title is applied through the conditional formatting (fx) option on the visual's Title property.

Preview of the Next Lesson:

We have now reached the final lesson of our course! In our next session, we will focus on finalizing and optimizing our work. You'll learn how to review your measures for clarity and consistency, identify common performance pitfalls, and use Power BI's built-in Performance Analyzer to find and debug slow-running DAX queries. This will be the final step in preparing your report for a real-world business audience.