set current week as 'default'

[nick9one1]

I have a slicer in a report that allows uers to select a week. The slicer shows the first day of every week as an option. 

The column looks up the row year '2023' and week number '35' to filter a Date Dimension table, and return a date from the first of week column. 

FW as Date = 
CALCULATE(
    MAX('Dim Date'[FirstOfWeek].[Date]),
    FILTER(
        ALL('Dim Date'),
        [FinancialYear]='Lettings Fact_Lettings_Summary'[FinancialYear] &&
        [FinancialWeek]='Lettings Fact_Lettings_Summary'[FinancialWeek]
    )
)

 

I would like to amend this so that the latest year and week value returned is formatted as a fixed text value e.g. 'Default'.
Then I can publish the report with 'default' selected in the slicer. Then as the report refreshes weekly and new weeks are added,

it will always present the data with the latest week selected (Default). 

Can anyone suggest how to do this? 

[MFelix · Accepted solution]

Hi @nick9one1 ,

To achieve this you need to create a new column on your dataset that for the current week presents a text "Current Week" and for the other ones present the Week end date you would need to sort by week end date.