Forum Discussion

Flavio2021's avatar
Flavio2021
Frequent Visitor
2 years ago
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 t...
  • lbendlin's avatar
    lbendlin
    2 years ago

    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")

     

     

     

  • Flavio2021's avatar
    Flavio2021
    2 years ago

    You are fully right !  I have complicated my life for nothing    Thank you ! it work as needed !

lbendlin's avatar
lbendlin
Super User
2 years ago

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")