preset filters, slicer or button to show last 7 days

[jcastr02]

Is there a 

preset filters, slicer or button to show last 7 days.  I have visuals that have comments from a survey and there is tons of content, but I just want something to press or hyperlink to show last 7 days or last month perhaps?

[Anonymous]

Hi @jcastr02 ,

There are so many ways to achieve this, But since you have mentioned Buttons I'm giving solution by using buttons slicer.

Here, I'm going to make Button which will show last week number when press. You could change the formula according to your requirement.

Create a new Column like This :

LastWeekButton =
VAR LastWeek =
    WEEKNUM ( TODAY () ) - 1
RETURN
    IF ( WEEKNUM ( 'Table.Date' ) = LastWeek, "Last Week", "Full Data" )

Now Use this column as a button slicer in your report.

Regards,

Gaurav Raj Singh

https://www.linkedin.com/in/gauravrajsingh/ 

[amitchandak]

Use a relative date slicer. The same option is available in Visual or Page level filter in filter pane

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

[dm-p]

Hi @jcastr02,

For simple cases, you can use relative date filtering in the filter pane or a slicer.

If you want something more interactive or customisable, this can be done, but due to the fact that dates overlap for multiple ranges (e.g. last 7 days, last month), you'll need to have a date table and then an additional 'time intelligence' table branching off that.

You can then make a slicer from your Period field in that table and it will filter your dates and cascade through accordingly.

It's quite tricky to cover in a reply without specifics, but Phil Seamark has written an excellent tutorial on how to set it up, and this works incredibly well. I use this design pattern over most of my financial reports. Hopefully this will be what you need.

Good luck!

Daniel

---

If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂