Filter slicer with last value by default

[Heeje_]

Hello all,

I wonder how to set by default a filter with most current date category by default. I have one slicer with 3 categories "Season 2024", "Season  2023", "Season 2022", and I want to set it by default with last category, that is, "Season 2024", that appears clicked.

Someone who can help me?

Thanks.

[Gabriele_hbto · Accepted solution]

You can accomplish this by substituting the current season name with "Current season." Add a column to the table and check if it's the current season. If it is, label it as "Current season"; otherwise, label it with the name of the season, such as "Season 2023."

Then, use this new column on the data of the filter and apply the filter to the current season then publish it in this manner.

Each time the data gets updated, the filter also gets updated to remain consistently on the current season.

hope i made my point and this is an aceptable solution for you