Forum Discussion

Memorable Member

5 years ago

Solved

How to make Column header display as Mar 2021 ?

Hi All Can some one advise me. https://www.dropbox.com/s/giwsd261tm9mslw/PBT_V2021_400%20GL_TI.pbix?dl=0 My PBI file :- Paul

Anonymous
5 years ago
Most of the solutions are recommending to use the unpivot option, try your luck with below links

https://community.powerbi.com/t5/Desktop/How-to-change-columns-names-automatically-in-Power-BI-desktop/td-p/1127719

https://community.powerbi.com/t5/Desktop/Dynamic-Variable-Column-Header-Names-Changing-with-Slicer/td-p/274812

Thanks,
Karthik
v-kelly-msft
5 years ago
Hi admin11 ,

Check the blog below:

https://www.fourmoo.com/2020/08/26/creating-dynamic-date-column-headers-in-table-matrix-names-in-power-bi/

It has details in the sample .pbix file,remember to download it.I'm definitely sure that it will be beneficial to you.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Anonymous

Not applicable

5 years ago

Hi Paul,

Do you want to keep your column headers changing on monthly basis?

Thanks,

Karthik

Memorable Member

5 years ago

I prefer the column header change on monthly basic. meaning on May 2021 , it show April 2021.

Anonymous
Not applicable
5 years ago
Most of the solutions are recommending to use the unpivot option, try your luck with below links

https://community.powerbi.com/t5/Desktop/How-to-change-columns-names-automatically-in-Power-BI-desktop/td-p/1127719

https://community.powerbi.com/t5/Desktop/Dynamic-Variable-Column-Header-Names-Changing-with-Slicer/td-p/274812

Thanks,
Karthik

Related content