Dynamic Column Header in Visualisation

Hi IshaDahra,

 

It's not possible to give dynamic name to a column header, you can give table a dynamic title though using below DAX

 

Dynamic Header =
"Deliverables | " &
FORMAT(EOMONTH(TODAY(), -1), "MMMM")

 

Not add this measure to Table title

 

if you still want to show dynamic title, create a card visual and place it above the column name and hide actual column name.

 

"Deliverables | " & FORMAT(EOMONTH(TODAY(), -1), "MMMM")

 

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

You cannot make a native table/matrix column header fully dynamic with a DAX measure when the column is a regular field like 'Table'[Short Descr].

 

Option 1) Rename it manually in the visual

If this is just for presentation, you can rename the field in the visual, but it stays static.

 

Option 2) Use a dynamic title above the visual

This is usually the cleanest workaround.

Create a measure like:

Dynamic Header =
"Deliverables | " & FORMAT ( EOMONTH ( TODAY(), -1 ), "MMMM" )

 

Hi IshaDahra ,

as suggested by others, creating dynamic column headers is not posssible in PowerBI.

However if your ask is to show current month then there are multiple ways to do this.

You can create a measure below for title and show that in table visual.

Dynamic Title= 
"Deliverables | " & FORMAT(EDATE(TODAY(), -1), "MMMM")

1. Then do below steps in your Visual.
2. Select your visual
3. Go to Format pane → General → Title
4. Click the fx button next to "Title text"
5. Set Format style = Field value
6. Select your Dynamic Title measure → OK

 

Please give kudos or mark it as solution once confirmed

Thanks and Regards,

Praful

LinkedIn