Forum Discussion
Dynamic Title with month name
Hi I created the Dynamic Title measure for the filter data from slicer table. and my slicer data is 1st Feb 2020.
but the result showing - Total YTD 01/02/2020. i just need the month name alone not the date format. below is my measure..can someone fix this.
Title YTD = IF(ISCROSSFILTERED(Rundate[KPI_MONTH])," Total YTD " & FIRSTNONBLANK(Rundate[KPI_MONTH], TRUE), "Total YTD ")
Thanks
Kavitha Ghosh
Anonymous ,
Try to use format
Title YTD = IF(ISCROSSFILTERED(Rundate[KPI_MONTH])," Total YTD " & format(FIRSTNONBLANK(Rundate[KPI_MONTH], TRUE),"MMM YYYY"), "Total YTD ")
Change format as per need
2 Replies
- amitchandak
Super User
Anonymous ,
Try to use format
Title YTD = IF(ISCROSSFILTERED(Rundate[KPI_MONTH])," Total YTD " & format(FIRSTNONBLANK(Rundate[KPI_MONTH], TRUE),"MMM YYYY"), "Total YTD ")
Change format as per need