How to make Last Day/Week/Month data filter

[Anonymous]

Helllo, everyone!

This is what I'm trying to build in Power B.I:

I have a lot of data with date and time info. The current filter I'm using is the basic one that looks like the custom in the image above. I want to create a filter with offset options where users choose last day/week/month/6months/year to show the data instead of manually typing the specific period.

I already have a simple Data dimension table but I couldn't figured out a way to create this filter.

Can anyone help me? 

[v-xulin-mstf · Accepted solution]

Hi @Anonymous

You can try this in Power BI with slicer:

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[daxer-almighty]

Does the Filter Pane not have such options built in? I know it does. Why then not use it?

It's also easy to create a mapping between dates and the type of period in a different table and connect it to the Date table. Then ppl will be able to select the type of period and DAX/Engine will do the rest.