Dynamic Titles

[evaeh]

Hello everyone!

Let's see if you can help me with a question:

I have some financial data that we want to put in columns called:
A23 (year 2023 in this case)
B23 (2023 budget)
A22 (Previous year, in this case 2022)
A19 (the year 2019, you always want to show it fixed)

We need that, when we put, for example, 2021 as the year to analyze in a filter, these titles change and are called A21, B21, A20 AND A19 (always static).

I explain? I don't know if there is any way to create these dynamic titles so that those measures change their name depending on the selected year.

Thank you!

[lbendlin]

power bi matrix dynamic column names at DuckDuckGo