Relative Date in a Title

[Pikachu-Power]

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?

Thanks. 

[amitchandak]

@Pikachu-Power , you can change slicer to relative date slicer https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

[Pikachu-Power]

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 🙂 

[v-jingzhang]

@Pikachu-Power 

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.

[Pikachu-Power]

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.

[Anonymous]

@Pikachu-Power  you can put the slicer on the canvas or if you want to use a dynamic title then use the below measure 

//Title=CONCATENATE("The selected value is",SELECTEDVALUE(Orders[City]))

Change Orders[City] with respect to your data 
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍