Forum Discussion
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 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
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")
2 Replies
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")