Matrix dynamic column header with YEAR and MONTH

[Pikachu-Power]

Hello,

I read some article about dynamic colums for matrix but couldnt find an appropriate way.

I have a matrix with 20 measures. And a YEAR and MONTH slicer. What I want is:

BEFORE:

Measures in the value field / the column name:

SALES YTD CY = CALCULATE...

SALES YTD CM = CALCULATE...

...

AFTER:

SALES YTD 2020 = CALCULATE...

SALES YTD 12 = CALCULATE...

...

Is that possible?

[Anonymous · Accepted solution]

@Pikachu-Power 
It is not possible to dynamically change the column name based on the slicer, my suggestion is just change the rename the column to best explain the situation, e.g. YTD(current/selected). 

In case you need measure help, you can use ISFILTERED function to show current and selected YTD value. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Pikachu-Power , The information you have provided is not making the problem clear to me. Can you please explain with an example.

are you looking for measure slicer ?
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME


Appreciate your Kudos.

[Pikachu-Power]

I want that the column headers changes dynamic when i choose YEAR and MONTH.