Dynamic Column Header change based on Year Slicer

[MIslam2020]

Hi Folks, I've slicer as FISCPER where values are 202001, 202101, 202201, 202301, 202401, 202501, 202601. I also have Budget Transfer detail table where I've column name AnnualM1, AnnualM2, AnnualM3, AnnualM4, AnnualM5, AnnualM6, AnnualM7, AnnualM8, AnnualM9, AnnualM10, AnnualM11, AnnualM12, AnnualYr1, AnnualY2, AnnualY3, AnnualY4, AnnualY5, Annualy6. 

Based upon FISCPER "2021001" Selection  AnuualM Column  will change to Jan-2021, Feb-2021, Mar-2021, Apr-2021.........Dec-2021 and then AnnualYr will turn to be as  2022, 2023, 2024, 2025, 2026, 2027. 
Not quite sure, how am i able to change the column hearder dynamically based on FISCPER in Power BI. 
Thank you.

[v-eachen-msft · Accepted solution]

Hi @MIslam2020 ,

If your "AnnualM" and "AnnualY" are in the different columns, you could split data as character and number. Then you could combine them as "YYYY-MM" type.

Here is a resolved case for your reference.

https://community.powerbi.com/t5/Desktop/Dynamic-column-header-in-Matrix/m-p/954608

[amitchandak]

Refer, if this can help

https://www.youtube.com/watch?v=TYLKDPcvgK8

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-format-visual-titles