Dynamically changing column headers in matrix based on selected value (calendar)

[milan674]

Hi everyone,

I want dynamically changing column headers in my matrix. The names of the columns should change based on the selected value in the slicer. If the name of my measure is "Selected year budget" and the selected value in the slicer is 2023.01. it should change to "2023 year Budget".

I have several other measures, like "Previous year budget", it should be "2022 year budget". And I have Selected year YTD budget measure as well, it should change to "2023 YTD budget"

Now it is working with labels implemented as cards, which were put over the original header ( I have cards with the selected year measure + "year budget") but this solution is not that good, and I suppose there is a way to solve this problem without doing a lot of work with formatting the Cards. 

Thanks!

[Idrissshatila]

Hello @milan674 ,

You don't need to have it in preview features, just go as in the screenshot

If I answered your question, please mark my post as solution, Appreciate your Kudos  👍

Follow me on Linkedin

[milan674]

Thanks, but we are using an older version, where we don't have field parameters at all. I have only a new parameter option,

[Idrissshatila]

Hello @milan674 ,

try using field parameters https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution, Appreciate your Kudos  👍

Follow me on Linkedin

[milan674]

@Idrissshatila,Thanks for your answer, but unfortunately we don't have preview features.