Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Am lookinbg to able to the 1st date of every month as column titles is there an easy way to do this
hi, @Anonymous
Do you mean that change the "UP to Jan" with "01/12/2017" and so on as column titles.
If so you just rename it manually.
Best Regards,
Lin
it needs to be rolling month on month, i dont want to have to do this manually as means running the report every month. I want to be able to let it automatically calculate it
hi, @Anonymous
For rename column titles automatically, I'm afraid it couldn't achieve in Power BI for now.
column titles are the attribute of table, you need to rename it manually.
Best Regards,
Lin

this is an example on what i am trying to recreate
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 22 | |
| 21 | |
| 21 | |
| 20 | |
| 13 |
| User | Count |
|---|---|
| 59 | |
| 53 | |
| 40 | |
| 31 | |
| 26 |