Dynamic Title

[Navaneeth]

I have a date slicer where im selecting between dates , however even when im selecting two dates from the slicer i m unable to get the dynamic title to show the title from which date to which date the data has been selected . 

I wanted to show that on a card or any other visual when ever i select the date , i should see the selected dates 

[Anonymous · Accepted solution]

Hi @Navaneeth 

Create a calendar date first . 

Table = ADDCOLUMNS( CALENDAR(DATE(2022,12,1),DATE(2023,1,6)),"Value",MONTH([Date])+DAY([Date]))

Then create a measure to return the Min date and Max date .

Dynamic Title = "Between "& MIN('Table'[Date]) & " and " &MAX('Table'[Date])

Add the measure in custom value in visual .

The final result is as shown below .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Navaneeth]

[FreemanZ]

@Navaneeth hi, what code do you have for the measure at the moment?

[tamerj1]

Hi @Navaneeth 
If you don't have complete contiguous dates then you need to use a date table for the slicer.