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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Flavio2021
Frequent Visitor

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
Super User
Super User

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
Frequent Visitor

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
Flavio2021
Frequent Visitor

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

lbendlin
Super User
Super User

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

 

 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors