Dynamically display only last 8 weeks data starting from today's date

[raojs12]

I have a data table with values assigned everyday. I would like to see a stacked column chart that shows previous 8 week data starting from todays date. In other words, dynamically show the weekly data for the last 8 weeks from latest date in report column. How can i do that PBI desktop?

[changqing · Accepted solution]

Hi @raojs12 ,

Try adding a Relative date filter for dates like this, which will automatically filter the data based on TODAY().

Best Regards,
changqing