Forum Discussion
Anonymous
5 years agoNot applicable
dynamic text box using filtered date
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" ...
- 5 years ago
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.
- 5 years ago
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:
- Create a measure like this:
Title = var _min=MINX(ALLSELECTED('Date'),[Date]) var _max=MAXX(ALLSELECTED('Date'),[Date]) return "Results between "&_min&" and "&_max- 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.
Mal_Sondh
Helper II
5 years ago
Are you able to re-attach the link to the pbi as i would like to view how you have done this..