Forum Discussion

SubZero07's avatar
SubZero07
New Member
2 days ago

Dynamic Latest Month Selection in a List Slicer

Hi everyone,

 

I've gone through a few existing discussions but haven't found a concrete solution, so I'd like to get some opinions on the following scenario.

 

Requirement:

 

I have a List Slicer using an MMM YYYY date field, configured for single selection. The issue is that when the dataset is refreshed and new month's data becomes available, the slicer selection does not automatically move forward to the latest month.

 

Workaround I've explored:

 

The List Slicer provides an option to display separate Values and Labels. Leveraging this, I created a substitute column with the following logic:

 

The latest available month is tagged as "Latest Month".

All other months retain their respective month-year values.

In the slicer, I use the substitute column as the underlying Value and the original MMM YYYY date column as the Label.

I then turn off the display of Values and keep Labels visible.

 

This allows the user to see the actual month-year (e.g., Nov 2026) while the underlying slicer selection remains "Latest Month".

 

Since "Latest Month" is a persistent value across dataset refreshes, the selection should remain intact, while the displayed month-year automatically updates as new data becomes available.

 

My questions:

 

Is this a valid and reliable approach to achieve dynamic latest-month selection?

Are there any potential caveats or side effects with this approach, particularly concerning persistent filters or slicer behaviour?

Is there a more native or recommended way to achieve this in Power BI without relying on a substitute column?

 

Would appreciate any insights or alternative approaches.

 

Thanks!

Need Help
Tips and Tricks

1 Reply

  • rampie's avatar
    rampie
    Icon for Kudo Commander rankKudo Commander
    1 day ago

    Your approach is actually the usual workaround and it's reliable, just make sure the "Latest Month" label column has the real month column set under Group By Columns (or sorted by it), so the selection sticks to the label and not to a specific month after each refresh. A couple of caveats: it only moves when the model refreshes, and users with persistent filters on will keep their last pick until they hit Reset to default.

    If you'd rather go native, try a Date picker slicer on the date column with a relative selection anchored to "Last date" (e.g. last 1 month), so it follows the latest data automatically: https://learn.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

    Hope this helps! https://www.linkedin.com/in/richard-ampie-218a07247/