Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
You will need to use a calculated table to generate these column names during each semantic model refresh.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |