Visual filter for sysdate -7

[Mystery]

Hi,

I have a report requirement where I have added a table and lot of measures in that table.I have to show all the measures for a date range = todays date -7.

 Is there a way to create a visual level filter on the table or I have to create separate measures to achieve the same.

Regards

[amitchandak · Accepted solution]

Try relative date slicing in visual or  page or report level filters

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

[ibarrau]

Hi! It deppends on the requirement. If you want to show the last 7 days of the last date in a table of your model, then you can add a visual level filter type "relative" with the date column. If you want last 7 days from NOW(), then you might need to create a column in your table comparing dates like "if you date column > last 7 days then yes else no". You can then add that new column in a visual level filter and check "yes".

Hope this helps, let me know if you need more assistant with the calculated column.

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