Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago
Solved

Dynamic Column Header

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

 

 

 

 

 

 

Need Help
  • ajaybabuinturi's avatar
    ajaybabuinturi
    1 year ago

    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.

4 Replies

  • ajaybabuinturi's avatar
    ajaybabuinturi
    Super User
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      v-dineshya
      Community Support
      1 year ago

      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.