Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
GE1
Advocate I
Advocate I

Dynamic Column Headers with Dates

For some reason I can't find the way to change the name of a column in a table or matrix dynamically. I can change the table title with a function, but not the column names.

I have a table (or matrix) with measures as the columns:
Column 1 is current month; Column 2 is previous month; Column 3 is the difference between Cols 1 and 2; Column 4 is 12 months ago; Column 5 is the 12 month average.

I want the names of the columns to change each month. So they would say:
Jul 24; Jun 24; Month Change; Jul 23; Aug 23-Jul 24 Average.

Obviously, next month they would say:
Aug 24; Jul 24; Month Change; Aug 23; Sep 23-Aug 24 Average.

Other than sticking cards over every column name(!) how can I do this?

Thank you

1 REPLY 1
lbendlin
Super User
Super User

You will need to use a calculated table to generate these column names during each semantic model refresh.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors