topic Re: Dynamic Title in DAX Commands and Tips

Dynamic Title

Navaneeth — Mon, 12 Dec 2022 11:22:46 GMT

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

Re: Dynamic Title

tamerj1 — Mon, 12 Dec 2022 11:33:04 GMT

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

Re: Dynamic Title

Navaneeth — Mon, 12 Dec 2022 12:13:21 GMT

Re: Dynamic Title

FreemanZ — Mon, 12 Dec 2022 13:21:27 GMT

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

Re: Dynamic Title

Anonymous — Fri, 06 Jan 2023 08:00:12 GMT

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.