Display either last 7 dates or 'ALL' the dates

[AshPower]

Using Slicer I want  user to be able to display last week data or all.

currently I have data for 30 days, it will grow as days pass by.

Right now using following calc column I am able to display last 7 days or (30 days - 7 days). 

Time Frame = if(AND(DailyStatus[Creation Date].[Date]>=[Today]-7,DailyStatus[Creation Date].[Date]),"Last 1 week","All")

I would like to diaplay slicer option of last 7 days or ALL

Thanks!

date DimLast 2 weekswant to show all but displays (All-last 2 week) dates

[v-huizhn-msft]

Hi @AshPower,

Have you resolved your issue? If you have, please mark the corresponding reply as answer. Or welcome to share your workaround.

Best Regards,
Angelia

[GilbertQ]

Hi @AshPower

What I would do in your situation, is I would have created a date table, and linked my main (FACT Data) to my Date table via the date column.

Then what I would do is the similar steps described below, to create a new column in my Date Table which would allow me to use a Slicer to show the last 7 days or all. In my blog post below it is for the current month, but we could easily change this to be for the last week.

You will then have to add a column in the Date Table with the following which will be going back 7 Days from Todays Date

Date.From(Date.AddDays(DateTimeZone.SwitchZone(DateTimeZone.FixedLocalNow(),10),-7))

NOTE: IN the above I have offset my time to 10 hours being in AEST, so you might need to change that to your local timezone.

Then I added another conditional column which then calculates if it is within the Past 7 Days

if [Calendar Date] >= [Past 7 Days] and [Calendar Date] <= [Current Date]
then "Past 7 Days"
else "All"

So that now my column will only have the value of the "Past 7 Days" when it is within the date range.

Power BI – Getting your report to always filter this month’s data dynamically

NOTE: I have uploaded the file to the blog post above which can show you the changes above.

[AshPower]

Hi

I am sorry but it is not working for me, still displaying past week or misus past week from all instead of All.

[parry2k]

here is an interesting link , hope it is helpful, if need more help, let me know

http://analyticsavenue.com/power-bi-timeperiod-slicer-for-last-7-dayslast-30-days/