How to make Column header display as Mar 2021 ?

[admin11]

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 · Accepted solution]

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-deskt...

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

Thanks,

Karthik

[v-kelly-msft]

Hi  @admin11 ,

Something like below?

Or you want the display changed according to the actual date?

Best Regards,
Kelly

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

[Anonymous]

Hi Paul,

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

Thanks,

Karthik

[admin11]

@v-kelly-msft @Anonymous 

I have received auto email from forum , asking me it this post i already get the answer i want ? 

I must said that i not yet get the answer i want , hope that some one can share with me how to achieve it ?

Paul Yeo

[v-kelly-msft · Accepted solution]

Hi  @admin11 ,

Check the blog below:

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

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!

[admin11]

@v-kelly-msft 

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

[Anonymous · Accepted solution]

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-deskt...

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

Thanks,

Karthik