Solved: Re: Default filter - Hermes

skip to main content

Reply

Hi All,

I want to create a slicer such as, whenever a user opens a report, it should be filtered to the latest date. Is there any way?

1 ACCEPTED SOLUTION

This has been covered many times. Please use the search function.

In a nutshell:

- 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

This has been covered many times. Please use the search function.

In a nutshell:

- 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

never-displayed

Helpful resources

Announcements

November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.