Default date slicer value is not updating

[Mmahachi]

Hello power bi gurus! I am working with school term data but have built out a pretty robust date table around that so i can find the most recent terms and sort them in order based on the school year but I can't get these default values to show up in the report when the data for the new term comes in. 

The requirement is to have the latest term selected automatically on the report in a single select slicer. I created a column on the date table that labels the latest term and it works if I use that column in the slicer but the requirement is to show the actual term value in the slicer so i.e. 23/24 Fall

Is there a way to do this? 

There is also a requirement on a separate page to select the most recent 4 terms, since this is a multiselect slicer I placed my labeled values in the second level of the hierarchy and checked off the 4 values (last term, two terms prior, 3 terms and same term previous year) but when the dataset is updated to include new terms the charts just blank out. 

Here is the slicer and how i have it saved for default but when a new term comes in say 23/24 winter that won't be selected even though at that time it will be the "latest term" the same four terms will be selected with the labels but since the labels no longer apply to the selected terms no data comes through.

I know it will work if the labels were selected in the first level of the hierarchy but the users do not want those values to show so is there a workaround?

these are the two columns the term name which they want visible in the slicer and my calculated column to indicate which term to default to

[lbendlin]

Here's the standard approach

- 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

This requires import mode and frequent (daily) refresh.

[Mmahachi]

thank you but my issue is if 'latest' is selected in any filter level then my slicer is not going to return all the date values or allow users to choose other dates. 

So I can get the default selection working and updating but only if what is selelcted shows up as some text e.g. latest as soon as I try to also include the date value it refuses to update to the latest date. 

so i don't want my default selection to just show as 'latest' as is on the left in the picture below. I want it default select something that looks like the text of the right "latest: actual term name"

Is this even possible? 

[lbendlin]

Not with custom terms.  It is possible with regular dates and Advanced Filtering in the Filter Pane (Relative Date)