Dynamic title using a date slicer

[maurcoll]

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 the slicer

date is coming from a calendar table, sales is from the sales table

I have tried using selected value but it only returns the text part not the date

[krishnakanth240 · Accepted solution]

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 · Accepted solution]

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

[krishnakanth240 · Accepted solution]

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")