Forum Discussion

maurcoll's avatar
maurcoll
Helper IV
3 months ago
Solved

Dynamic title using a date slicer

Hi   I need help creating a dynamic title slicer that uses the date slicer set at between     I need for example Total Sales 1 Jan 2025 - 31 Dec 2025 based on the selection made in th...
Need Help
  • krishnakanth240's avatar
    krishnakanth240
    3 months ago

    Hi maurcoll 

    Can you try this measure in card visual and check based on slicer selection

     

    Dynamic Title =

    "Total Sales " & FORMAT(MIN('Calendar'[Date]), "dd MMM yyyy") & " - " & FORMAT(MAX('Calendar'[Date]), "dd MMM yyyy")

  • Ritaf1983's avatar
    Ritaf1983
    3 months ago

    Hi maurcoll 

    Titte = "Total sales " & format ( min(calendar_table[Date]), "dd mmm yyyy" )&  " - "&  format ( MAX(calendar_table[Date]), "dd mmm yyyy" )

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Ritaf1983's avatar
Ritaf1983
Super User
3 months ago

Hi maurcoll 

Titte = "Total sales " & format ( min(calendar_table[Date]), "dd mmm yyyy" )&  " - "&  format ( MAX(calendar_table[Date]), "dd mmm yyyy" )

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly