Forum Discussion
Current week
Hello,
I am having some trouble.
I need a button that if you click on it, it will filter everything by the current week. I need current day to last 6 days.
Does anyone know how todo this. Is this even possible?
Thank you.
3 Replies
Hi lucpaymetals ,
You could add that logic to your date dimension as an additional column. After, you could use a slicer?
Would that work? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/I am not sure what you mean
Hi lucpaymetals ,
You can add a column to your date dimension like the below (either as a calculated column or in Power Query):
Then you can use that attribute in a slicer like below:
Or if you filter the slicer with just one value, you can actually change the slicer to the "Tile" style to get a button experience:
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
