Forum Discussion

tmhalila's avatar
tmhalila
Resolver II
2 years ago
Solved

Dynamic Slicer to select previous week as default

Hello team, I need your help I have a dataset that tracks daily events with report date and that date is in relationship with the dim_date attached to this post. I want to add a column in the dim_da...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    2 years ago

    That is possible but only if your Calendar table is sourced in Import Mode and is refreshed at least weekly.

     

    Here's the standard pattern (adjust to your needs):

    - create a string representation of your date column, replace the latest date with a string "Latest"
    - sort that new column by the original date column
    - add a slicer or visual/page/report level filter
    - set the filter to "Latest"
    - publish the pbix to the workspace/app

  • tmhalila's avatar
    tmhalila
    2 years ago

    I tried to add this mesure it worked fine!

     

    cx_last_week = 
VAR max_date = MAX(dim_date[cx_end_of_week])
RETURN 
 If(dim_date[cx_end_of_week] = max_date -7, "Last week", dim_date[weekly_start_monday_day_dates])

     Thanks for your time  

Nayan_surya's avatar
Nayan_surya
Helper I
2 years ago

Hi tmhalila ,

 

My client also had this requirement that he needed to last week by default without any bookmark. What we ended up doing was buying a custom visual named Date Picker by Powerviz. It had this feature of default selection built in so made the job easy and the client happy.

 

 

if you can see in the above example the max week is selected by default.

 

I think you should check them out.

Here is a link if you want to check this visual - https://appsource.microsoft.com/en-us/product/powerbivisuals/truvizinc1674781244292.date-picker-by-p...  (I believe they offer a free version too)