Forum Discussion

Vcaze's avatar
Vcaze
Frequent Visitor
2 years ago

Dynamic Column Headers in Power BI Matrix Based on Year Selection

Good afternoon, I’m hoping someone can help me with this limitation in Power BI. I’m building a report that includes some Matrix visuals where I’ve placed a field parameter in the Rows and a few met...
Need Help
SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
2 years ago

Hi Vcaze 

 

I could be wrong but I don't believe so.

Instead you can insert a blank button: Insert | Buttons | Blank Button

 

Then set the Text equal to a measure:
Dynamic Button text = "Sales " & SelectedValue(table[year])

 

 

  • SamWiseOwl's avatar
    SamWiseOwl
    Icon for Super User rankSuper User
    2 years ago

    Vcaze  You can make the visual title dynamic.

    That way it reads 2024 above all of them.

     

    • Vcaze's avatar
      Vcaze
      Frequent Visitor
      2 years ago

      Thank you for your answer. I know that the title can be dynamic, but I really need to dynamically change the column names.

      Thank you.