Dynamic Column Header in Visualisation

[IshaDahra]

Hi,

I have made a column in my table and added it to visualization. It's name is "Short Descr". I have changed it to "Deliverables". I want to change it automatically every month like "Deliverables | February", if the current month is March.

[grazitti_sapna · Accepted solution]

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!

[cengizhanarslan · Accepted solution]

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" )

[V-yubandi-msft]

Hi @IshaDahra ,

We haven’t received a response from your end yet. Please let us know whether the issue has been resolved or if you’re still facing any difficulties. Feel free to reach out if you need further assistance.

[V-yubandi-msft]

Hi @IshaDahra ,

If you get a chance, please review the response shared by @cengizhanarslan , @Praful_Potphode and let us know if it aligns with your expectations. Should you need any additional details or clarification, feel free to let us know.

Thank you for your valuable input.

Regards,
Yugandhar.

[Praful_Potphode · Accepted solution]

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

[cengizhanarslan · Accepted solution]

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" )

[grazitti_sapna · Accepted solution]

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!

[grazitti_sapna]

Hi @IshaDahra,

If the issue is fixed, kindly mark it as a accepted solution