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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Flavio2021
New Contributor III

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

 

 

 

 

2 ACCEPTED SOLUTIONS
lbendlin
Esteemed Contributor III

lbendlin_0-1712622281406.png

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

 

 

 

View solution in original post

Flavio2021
New Contributor III

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

View solution in original post

2 REPLIES 2
lbendlin
Esteemed Contributor III

lbendlin_0-1712622281406.png

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
New Contributor III

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

Helpful resources

Announcements
Users online (3,586)