Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

CREATE DINAMIC TITLE

How can I create a dynamic title with the selected dates of the data slicer?

WEEKLY PLAN 25 TO 26 FEBRUARY?

faraya_0-1614446269354.png

  • Try the measurement below

    Measure - "Weekly Plan" and FIRSTDATE(Table[Date]) and " to " & LASTDATE(Table[Date])

    Best regards

  • Hello.

    Try the measure below

    Measure = "Plan Semanal " & FIRSTDATE(Table[Date]) & " al " & LASTDATE(Table[Date])

    Best Regards

4 Replies

  • Portrek's avatar
    Portrek
    Resolver III

    Try the measurement below

    Measure - "Weekly Plan" and FIRSTDATE(Table[Date]) and " to " & LASTDATE(Table[Date])

    Best regards

  • Hello.

    Try the measure below

    Measure = "Plan Semanal " & FIRSTDATE(Table[Date]) & " al " & LASTDATE(Table[Date])

    Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Syndicate_Admin 
    I would instead create a measure to suit if the date ranges across multiple months.

     

    Dynamic Title = "Weekly Plan " & FORMAT(MIN(table[date]),"DD-MMM") & " to "  &FORMAT(MAX(table[date]),"DD-MMM")