Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Tlotly
Resolver II
Resolver II

Week slicer to default to latest week

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?

Tlotly_0-1647526394637.png

 

Thank you

Matlotlo

 

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

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)

1.jpg

2.jpg

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

8 REPLIES 8
v-jayw-msft
Community Support
Community Support

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)

1.jpg

2.jpg

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Hi @v-jayw-msft ,


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

PVO3
Impactful Individual
Impactful Individual

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'

PVO3_0-1647526842903.png

 

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

Tlotly_1-1647527372248.png

 

 

PVO3
Impactful Individual
Impactful Individual

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

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

 

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

 

Thank you

 

PVO3
Impactful Individual
Impactful Individual

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

HB13
Helper I
Helper I

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors