dynamic text box using filtered date

[Anonymous]

Hello, 

I would like to create a text box to add a title for my report which includes the dates applied in the date filter.
The title would look like "Results between XX/XX/XXXX and XX/XX/XXXX"

Thank you for your help
Pauline

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please try to write the below DAX measure for your title.

Titlename =

"Results between " & MIN( dates[Date]) & " and " & MAX(dates[Date])

Jihwan Kim

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.

[Mal_Sondh]

@v-robertq-msft

Are you able to re-attach the link to the pbi as i would like to view how you have done this..

[v-robertq-msft]

Hi, 

Sorry, my OneDrive account has been expired and the pbix file has been deleted.

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @v-robertq-msft and @Jihwan_Kim 

It works but it's a shame that we have to create a measure for each chart title if we want it to be different.

Have a nice day

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, I think you can create a measure and set the text box title as the value of the measure to achieve this, you can try my steps:

1. Create a measure like this:

Title =
var _min=MINX(ALLSELECTED('Date'),[Date])
var _max=MAXX(ALLSELECTED('Date'),[Date])
return
"Results between "&_min&" and "&_max

2. Add a text box and set the title like this:

And add a date slicer to your page, then you can get what you want, like this:

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please try to write the below DAX measure for your title.

Titlename =

"Results between " & MIN( dates[Date]) & " and " & MAX(dates[Date])

Jihwan Kim

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.