Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful 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: ...
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.

ajaybabuinturi's avatar
ajaybabuinturi
Icon for Super User rankSuper 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.