Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jmoedata
Frequent Visitor

Default slicer selection to max value

Is there a way to have the value of a slicer to be the max date of the column that the slicer is built from? i.e. if the distinct values in the table are:

* 2024-03-01

* 2024-04-01

* 2024-05-01

* 2024-06-01

 

We would want the selected value = 2024-06-01.  When the data for 2024-07-01 is loaded, I would want to default slicer value = 2024-07-01 without having to go into the report, change the slicer value, save the report, and republish.

 

Thanks!

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

This is the standard pattern in such a scenario:


- 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

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

This is the standard pattern in such a scenario:


- 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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.