Forum Discussion

Tlotly's avatar
Tlotly
Icon for Helper V rankHelper V
4 years ago
Solved

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?

 

Thank you

Matlotlo

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

8 Replies

  • HB13's avatar
    HB13
    Icon for Helper I rankHelper I
    4 years ago

    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

  • PVO3's avatar
    PVO3
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    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's avatar
      Tlotly
      Icon for Helper V rankHelper V
      4 years ago

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

       

       

      • PVO3's avatar
        PVO3
        Icon for Impactful Individual rankImpactful Individual
        4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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_'s avatar
      PBI_
      Frequent Visitor
      2 years ago

      Hi Anonymous ,


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