Forum Discussion
dynamic text box using filtered date
- 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.
Hi, Anonymous
Please try to write the below DAX measure for your title.
Jihwan Kim
If this post helps, then please consider accept it as the solution to help the other members find it more quickly.