Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Goal: I have a date slicer of date hierarchy (year, quarter, month). Based on user's selection, I need to create a dynamic title that captures all year, quarter, and month selected. Quarter(s) and month(s) follow after their respective year. For example, 2023 Q1 M1, 2 & 2024 Q2 M4. The title can get long but I will keep the question simple for now and worry about the length later.
Data Model: One fact table and one calendar table related by the [Date] column. Calendar table was generated from the [Date] column in the fact table. The calendar table has following 4 columns: [Date] - date type, [Year] & [Quarter] & [Month] - whole number type.
This question is about the date slicer selection. I will save the time by not involving the fact table here.
DAX I need help with:
Title =
Solved! Go to Solution.
Title =
VAR SelectedYears =
SUMMARIZECOLUMNS(
'Calendar'[Year],
'Calendar'[Quarter],
'Calendar'[Month]
)
RETURN
CONCATENATEX(
SelectedYears,
[Year] & " Q" & [Quarter] & " M" & [Month],
" & "
)
@lbendlin You are such a genius! Your DAX is simple and works wonder. I could have stopped here. But I added a few lines on top of your DAX to produce the right format for my situation - reduced the title length just a little bit.
Title =
VAR SelectedYears =
SUMMARIZECOLUMNS(
'Calendar'[Year],
'Calendar'[Quarter],
'Calendar'[Month]
)
RETURN
CONCATENATEX(
SelectedYears,
[Year] & " Q" & [Quarter] & " M" & [Month],
" & "
)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |