Filter the date drop down

Power BI
1

hello,
as you see in the drop down I am showing the last 30 days of the dates.
How is it possible so that the last 7 days of this list i.e. from today till -7 days are ticked when the page is loaded?
This way the table is filtered for the last 7 days but the user can select up to -30 days if required?
thanks

image
image423×661 16.8 KB

2

@arkiboys You can create a Calculated Column like below
PeriodInRange = IF(DATEDIFF('Table'[Date],TODAY(),DAY) <= 7 && DATEDIFF('Table'[Date],TODAY(),DAY) >= 0, TRUE(), FALSE())
and put this in a filter pane and select TRUE.
Let me know if that works for you. Thanks

3

Hello @arkiboys

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

4

thank you