DAXDAX Trainer

DAX Concept

Dynamic Report Title with Slicer Selections using ISFILTERED, VALUES, and CONCATENATEX

Learn to create a dynamic measure for a report title that automatically updates based on user selections in a slicer, handling single, multiple, or no selections.

IntermediateISFILTEREDVALUESCONCATENATEX

Concept Breakdown

This exercise leverages several key DAX functions for dynamic reporting. The ISFILTERED function checks if a specific column (e.g., Voting[Area]) is currently being filtered. The VALUES function returns a table of distinct values from a column, which can be implicitly converted to a scalar value if only one distinct value exists. When multiple values are selected, CONCATENATEX iterates over the selected values and concatenates them into a single string, perfect for displaying multiple selections in a title.

What You Will Learn

  1. Understand when to use ISFILTERED, VALUES, CONCATENATEX in a Power BI model.

  2. Practice the concept inside a real PBIX report rather than only reading syntax.

  3. 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.

  1. Download and unzip the provided Power BI file.

  2. Open the Power BI file and navigate to the report page.

  3. Locate the 'Title' measure used for the report's dynamic title.

  4. Edit the 'Title' measure: Use ISFILTERED(Voting[Area]) to check if an area is selected. If not filtered, display 'Brexit Referendum Results for All Areas'. If filtered, use VALUES(Voting[Area]) to display 'Brexit Referendum Results for ' followed by the selected area name.

  5. (Optional but recommended) Modify the 'Area' slicer properties to allow 'Multi-select with CTRL' and 'Show 'Select all' option'.

  6. Enhance the 'Title' measure: If multiple areas are selected, use the CONCATENATEX function to list all chosen areas, formatted as 'Brexit Referendum Results for Area1, Area2, Area3'.

  7. Test the measure by selecting single, multiple, and no areas in the slicer.

  8. Save the Power BI file as 'Happy memories'.

Starter DAX

Title = "Default Report Title"

Expected Outcome

The report title will dynamically change:

  • 'Brexit Referendum Results for All Areas' when no areas are selected in the slicer.
  • 'Brexit Referendum Results for [SelectedArea]' when a single area is chosen.
  • 'Brexit Referendum Results for [Area1, Area2, Area3]' when multiple areas are selected.
Checking your sign-in status...