Current week

[lucpaymetals]

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.

[tackytechtom]

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/

[tackytechtom]

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/

[lucpaymetals]

I am not sure what you mean