Display latest date by default in a date slicer

[Sashankv]

Hi I am using a drop down date slicer in which i wanted to see all the dates available in data base . one the server by default it should select the latest date available and users must be able to select historical dates as well.

eg: jan 2025    ( by default when i open Jan 2025 should be selected.)

      dec 2024 

      nov 2024

     oct 2024 

[lbendlin · Accepted solution]

Here is the general approach. Adjust as needed
- 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

[v-sathmakuri]

Hi @Sashankv ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Anonymous]

Hi @Sashankv ,

Any update on this? Did these suggestion helps for your scenario? If not, please provide some more detailed informations about your requirement.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Sashankv ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[danextian · Accepted solution]

Hi @Sashankv 

If you want "exactly" the latest date to be selected by default then you will need do a bit of modification using Tabular Editor.  You can leverage the Group by Columns property to "store a filter by using an alternate value, which represents the key of the entity." Power BI uses this key to store the filter, allowing the corresponding filter value in the visual to change dynamically. For instance, if May-24 is selected in the visual and currently has a key of 0, when June arrives, May will shift to a key of 1, and June will take the key of 0. Consequently, the slicer selection will automatically change to June.

Here's a demo and further reading is in the description - https://youtu.be/MrEAZREQuXM?si=B5ko-XWYZHJqkeYD 

Note: Persistent filters override dynamically selected slicer value/s.

[lbendlin · Accepted solution]

Here is the general approach. Adjust as needed
- 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