Forum Discussion

dainova's avatar
dainova
Regular Visitor
1 year ago
Solved

How add dynamic filter value (for date )

Hi, How I can implement my filter  for date 7 days from now in my filter like in example below. I've created Last7Days measure but can not move into the filter box, tried all types of filtering. ...
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    You can’t put a measure in the filter pane.


    Use one of these:

     

    Relative date filtering on your Modified On column → set to last 7 days.

    Or create a column:

     

    IsLast7Days =
    IF('Table'[Modified On] >= TODAY()-7 && 'Table'[Modified On] <= TODAY(), 1, 0)


    Then filter IsLast7Days = 1.

Ritaf1983's avatar
Ritaf1983
Super User
1 year ago

Hi dainova 
You can create flag column in the calculated table, with the formula like:

Last 7 days flag = if('Calendar'[Date]>= TODAY()-7 && 'Calendar'[Date]< TODAY(),1,0)
This column can be used as a filter in all the levels ( visual / page/ all pages)

The pbix with the example is attached

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