https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Default-filter/m-p/2642729#M4677 <P>This has been covered many times. Please use the search function.</P> <P>&nbsp;</P> <P>In a nutshell:</P> <P>- create a string representation of your date column, replace the latest date with a string&nbsp; "Latest"</P> <P>- sort that new column by the original date column</P> <P>- add a slicer or visual/page/report level filter</P> <P>- set the filter to "Latest"</P> <P>- publish the pbix to the workspace/app</P> Sat, 16 Jul 2022 23:17:45 GMT lbendlin 2022-07-16T23:17:45Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Default-filter/m-p/2638163#M4670 <P>Hi All,</P><P>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?</P> Thu, 14 Jul 2022 08:48:10 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Default-filter/m-p/2638163#M4670 Anonymous 2022-07-14T08:48:10Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Default-filter/m-p/2642729#M4677 <P>This has been covered many times. Please use the search function.</P> <P>&nbsp;</P> <P>In a nutshell:</P> <P>- create a string representation of your date column, replace the latest date with a string&nbsp; "Latest"</P> <P>- sort that new column by the original date column</P> <P>- add a slicer or visual/page/report level filter</P> <P>- set the filter to "Latest"</P> <P>- publish the pbix to the workspace/app</P> Sat, 16 Jul 2022 23:17:45 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Default-filter/m-p/2642729#M4677 lbendlin 2022-07-16T23:17:45Z