How to create a filter for today, yesterday, this week, this month?

[bourne2000]

Hi

I am having date table, sales, order, and other tables. All connected. I would like to create a filter with today, yesterday, this week, this month for my summary page.

Could you please advise how to do?

This is my date table

[bourne2000]

Hi @Jihwan_Kim 

Thanks, yes I am looking exactly the same. However, when I checked your pbix, I can't see any relationship between the date slicer with date and sales table. But, it's working fine. Can you please advise?

[Jihwan_Kim]

Hi, @bourne2000 

Thank you for your feedback.

The slicer table is made in Tabular Editor and it is a calculation group.

No need to connect with any other tables in the model.

Thank you.

[Jihwan_Kim · Accepted solution]

Hi, @bourne2000 

I am not sure if I understood your question correctly.

Please check the below picture and the sample pbix file's link down below.

I tried to create a sample pbix file based on the explanation.

I suggest creating a slicer by using Tabular Editor in Power BI.

https://www.dropbox.com/s/4r7p9pckj3oxhc5/bourne.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM