Forum Discussion
Dynamic Slicer
It's going to use the selected value in the slicer, so the slicer value itself can't have the date in it if you want it to be dynamic. What you can do as a workaround is add the actual selected date to the slicer header or title using a measure to for the selected date value (you'll need to format it with FORMAT()). You could have it read something like "Current week selected (mm/dd/yy - mm/dd/yy)" where the dates are the actual dates.
Hello,
Thanks for getting back to me. The problem with this is I don't want to use Text like "Current Week", "Last Week", etc.. I have already implemented a solution just like that and my client did not like it. They want it to display the date.
It's going to use the selected value in the slicer, so the slicer value itself can't have the date in it if you want it to be dynamic. What you can do as a workaround is add the actual selected date to the slicer header or title using a measure to for the selected date value (you'll need to format it with FORMAT()). You could have it read something like "Current week selected (mm/dd/yy - mm/dd/yy)" where the dates are the actual dates.