Dynamic Date Column name

Hi UnknownUser32,

 

Thank you for providing the details and sample structure, it’s very helpful. Currently, Power BI does not support dynamically renaming matrix column headers based on slicer selections (for instance, changing the column name to “Value of August 2025” or “Value of July 2025” automatically). While measures like your last_month using PARALLELPERIOD will update values according to the month slicer, the column headers themselves remain static.

A typical workaround is to use generic measure or column names in the matrix (such as Current month, Previous month, Last year) and display the selected month and year using dynamic text in card visuals above the matrix. For example, you can create measures like:
CurrentMonthLabel = "Value of " & FORMAT(SELECTEDVALUE('Calendar'[CALENDAR_ID]), "MMMM yyyy")
PrevMonthLabel = "Value of " & FORMAT(EOMONTH(SELECTEDVALUE('Calendar'[CALENDAR_ID]), -1), "MMMM yyyy")
and use these cards as “pseudo-headers.” When the slicer changes from August to September, these cards will update automatically to show “Value of August 2025 vs Value of July 2025”. For dynamic labels directly in the matrix, custom visuals like Inforiver Matrix or advanced setups with field parameters or calculation groups may be needed, as the default matrix does not support this feature yet.

 

Thank you.