Forum Discussion
Relative Date in a Title
Hello. I have a relative date slicer on a filter pane. because it is a little bit hidden I want to show it a title or on the canvas. is that posibble? or do i have to put the slicer on the canvas...
I was thinking about a title that shows me what is filtered... last 3 weeks, last 5 year... everything that is possible with relative date 🙂
How about creating a measure like below and put it in a card visual?
Date Range = FIRSTDATE('Calendar'[Date]) & " - " & LASTDATE('Calendar'[Date])
Date Range 2 = "Last " & DATEDIFF(FIRSTDATE('Calendar'[Date]),LASTDATE('Calendar'[Date]),DAY) & " Days"
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
Good approach. Is it also possible to write dynamic days/month/year? And there is more possibilities as last.
Actually i would like to put the relative date on the canvas but there is still no possibility to control the beginning of the week. I would like to see a calender week from monday to sunday.