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 a...
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
amitchandak
Super User
Super UserAnonymous ,
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
Thanks Amit!!!!