Forum Discussion
Solved
Dynamic title based on slicer date timeframe
Hi I am looking for create a dynamic title that report in the title the start and end date, selected from a list of dates that can be also multiple event in the same day.
Looking around, not found the right suggestion for manipulate it correclty, so far
Somone can help me ? Here the PBIX you can use as example
Note that you have too many date values in your slicer, so sampling will occur.
Title = "Number of item from " & FORMAT(min('Table'[Date Created]),"m/d/yyyy") & " to " & format(max('Table'[Date Created]),"m/d/yyyy")You are fully right ! I have complicated my life for nothing Thank you ! it work as needed !
2 Replies
Note that you have too many date values in your slicer, so sampling will occur.
Title = "Number of item from " & FORMAT(min('Table'[Date Created]),"m/d/yyyy") & " to " & format(max('Table'[Date Created]),"m/d/yyyy")You are fully right ! I have complicated my life for nothing Thank you ! it work as needed !