https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Set-default-slicer-to-highest-date-in-data-set/m-p/3566133#M8442 <P>Hi,</P><P>&nbsp;</P><P>i have a date slicer with some (random) date values.</P><P>How can I achieve that when opening the report the default is set on the <STRONG>maximum</STRONG> value?&nbsp;</P><P>Easy question but i don't seem to get it done. Any help is much appreciated...</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Mon, 04 Dec 2023 12:53:31 GMT eyeekit 2023-12-04T12:53:31Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Set-default-slicer-to-highest-date-in-data-set/m-p/3566133#M8442 <P>Hi,</P><P>&nbsp;</P><P>i have a date slicer with some (random) date values.</P><P>How can I achieve that when opening the report the default is set on the <STRONG>maximum</STRONG> value?&nbsp;</P><P>Easy question but i don't seem to get it done. Any help is much appreciated...</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Mon, 04 Dec 2023 12:53:31 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Set-default-slicer-to-highest-date-in-data-set/m-p/3566133#M8442 eyeekit 2023-12-04T12:53:31Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Set-default-slicer-to-highest-date-in-data-set/m-p/3576580#M8460 <P>Here is the default approach. Adjust as needed.</P> <P>- create a string representation of your date column, replace the latest date with a string "Latest"<BR />- sort that new column by the original date column<BR />- add a slicer or visual/page/report level filter<BR />- set the filter to "Latest"<BR />- publish the pbix to the workspace/app</P> Mon, 11 Dec 2023 01:46:16 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Set-default-slicer-to-highest-date-in-data-set/m-p/3576580#M8460 lbendlin 2023-12-11T01:46:16Z