filter with choices Last 7 days, last 14 days and this Year

[Meeresblume]

Hello,

Is there a way to create the filter like this?

The user should have 3 buttons to choose from in which the filtering of the table below can be adjusted. The buttons should read Last 7 days, Last 14 days and This year. He should also have the opportunity to independently select a date range.

Example:

Thanks for your help

[Anonymous · Accepted solution]

Hi @Meeresblume ,

One option would be to create a calculation group with items for each period you want to cover, e.g.

Last 7 days =
CALCULATE (
    SELECTEDMEASURE (),
    DATESBETWEEN ( 'Date'[Date], TODAY () - 7, TODAY () )
)

Last 14 days =
CALCULATE (
    SELECTEDMEASURE (),
    DATESBETWEEN ( 'Date'[Date], TODAY () - 14, TODAY () )
)

last year =
CALCULATE (
    SELECTEDMEASURE (),
    DATESBETWEEN ( 'Date'[Date], EOMONTH ( TODAY (), -13 ) + 1, TODAY () )
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mh2587]

If you have measures for last 7 days , last 14 days and this year ,  Just drag those measures in field parameter and put the measure value of this parameter in visual so it will suit your requirements

[Meeresblume]

It is a normal date (01-01-2023). I don't have Measure and I wouldn't know how I should create it so that it fits the selection.