Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Yash_Kumar_CDA
New Member

Dynamic Column Name Based on Date

Hi Team

I Need to have Dynamic column Name for Selected month 

i.e. I have created till the point with the use of parameter where using today

when the data is static 

I want that the title also changes when I select the different Month

 

Thanks In Advance

1 REPLY 1
amitchandak
Super User
Super User

@Yash_Kumar_CDA , Column can not refer values in slicer and filter, the best you can hve like

 

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

 

 

Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]=TODAY()-2,"Day before Yesterday"
,'Date'[Date]&"")

 

and default the slicer based on that Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.