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.
MacBI , You need to create a Column like
Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"This Week" ,
[start week]<=Today()-7 && [end date]>=Today()-7,"Last Week" ,
[Week Name]
)
And save it for this week.
For week start and end date
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e6f593958
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.
