Week slicer to default to latest week

[Tlotly]

Good day

I was wondering if it's  possible to have a week slicer defaulted to the latest week when opening a report. I've tried several ways I  found here on the community but they're not working for me. Also I can create measures which will default the visual to the latest week's results but the matrix I have cannot handle such, it hangs due to the granularity of my dataset.

Below is my week slicer,  which I want it to have 2022/03/14 as a default selection and when a new week comes it then defaults it to that new week automatically. Is this possible?

Thank you

Matlotlo

[v-jayw-msft · Accepted solution]

Hi @Tlotly ,

Create a measure as below and add it to visual filter set value = 1.

Measure = IF(SELECTEDVALUE(Data[meeting_process_date]) = MAXX(FILTER(ALLSELECTED('Calendar'),'Calendar'[WeekSlicerDates]=TRUE()),'Calendar'[WeekStart]),1,0)

Best Regards,

Jay

[PBI_]

Hi @v-jayw-msft ,

Can you do a sample pbix file and share it to me plz......

[PVO3]

Use your [Date] field als a filter on the visual/page and set it to relative date in the last week.

And put a 1 in the blank above 'weeks'

[Tlotly]

I did the relative date even before posting but as soon as I select another week I get blank results.

[PVO3]

Can you please show images of you date table & model?

[Tlotly]

@PVO3  I've attached a link with the PBI. 

 https://www.dropbox.com/s/3a1zlpo12ve6kvp/WeekDefault.pbix?dl=0 

Thank you

[PVO3]

Sorry I totally missed your reply. Fortunatly this is solved.

[HB13]

Hi there

You can try setting a Relative Date with the parameters This Week, it'll then update at the start of each new

week. You can find it by clicking the drop down arrow next to the "Week Start Date" title