Dynamic column headers in matrix

[sharong]

Dear Team,

I have a matrix visual. I want the column headers to change according to slicer selection. If the slicer selection is 2023-02, then i want the headers to be as

Current period = 2023-02 and previous period as 2022-02

Kindly help me in this.

[FreemanZ]

hi @sharong 

Header text is the name of the column or measure, which can't be dynamic. 

As a workaround. try to: 

1) hide the headers by setting the same color as the background. 

2) place a card visual or textbox with such code instead:

Current Period =

VAR _period =SELECTEDVALUE(TabelName[Select Fiscal Period])

RETURN

_period & " and previous period as " & SUBSTITUTE(_period, "23", "22")