Dynamic Column Header

[powerbiexpert22]

I am using below data, if i select year 2023 in slicer then column header should display as "Revenue for 2023' which is 260 and "Previous Year Revenue " which is 150 as shown below

Raw Data:

Slicer:

Expected Results

[Anonymous]

Hi @powerbiexpert22,

Thank you for reaching out in Microsoft Community Forum.

Thank you @ajaybabuinturi , @mh2587   for the helpful response.

As suggested by ajayBuinturi, mh2587., I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.

[v-dineshya]

Hi @powerbiexpert22 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[ajaybabuinturi · Accepted solution]

Hi @powerbiexpert22,
Power BI currently doesn't support the column headder change dynamically. But there is a workaround keep the text boxes on column headder and group them all together. You can achive your requirement.

Measure 1(For selected year) = "Revenue for " & SELECTEDVALUE('DateTable'[Year])

Measure 2(For previous year) = "Revenue for " & SELECTEDVALUE('DateTable'[Year])-1

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

[mh2587]

Referring you to the following article might help you
https://inforiver.com/blog/general/dynamic-column-headers-power-bi/