Forum Discussion
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...
Kedar_Pande
Super User
Super UserDynamic Current Year Sales Name =
"Sales " & SELECTEDVALUE(Year[Year])
Dynamic Previous Year Sales Name =
"Sales " & (SELECTEDVALUE(Year[Year]) - 1)
Use a Card visual to show dynamic names created in the measures above and place it on the column header.
Direct column headers in the Matrix can't change dynamically, but using additional visuals can help simulate this effect.
If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Thank you for your help. That solution works for Matrix with few columns, which is not my case.
Thank you for your time