Forum Discussion
Dynamic Column Header in Visualisation
- 5 months ago
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! - 5 months ago
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" ) - 5 months ago
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")- Then do below steps in your Visual.
- Select your visual
- Go to Format pane β General β Title
- Click the fx button next to "Title text"
- Set Format style = Field value
- Select your Dynamic Title measure β OK
Please give kudos or mark it as solution once confirmed
Thanks and Regards,
Praful
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")
- Then do below steps in your Visual.
- Select your visual
- Go to Format pane β General β Title
- Click the fx button next to "Title text"
- Set Format style = Field value
- Select your Dynamic Title measure β OK
Please give kudos or mark it as solution once confirmed
Thanks and Regards,
Praful