https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Filtering-data-through-yeterday/m-p/4607167#M12299 <P>Thank you!&nbsp; Is there a way to do it on the visual level instead of adding to the dataset?</P> Wed, 12 Mar 2025 14:59:30 GMT JSmart913 2025-03-12T14:59:30Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Filtering-data-through-yeterday/m-p/4601075#M12263 <P>I have a report where I want to filter the dat up through yesterday automatically without having to have a slicer and changing the day on the slicer every morning.&nbsp; Is this possible?&nbsp; Basically I would want to see number of sales and number of expected sales for the month up through yesterday</P> Fri, 07 Mar 2025 20:02:22 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Filtering-data-through-yeterday/m-p/4601075#M12263 JSmart913 2025-03-07T20:02:22Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Filtering-data-through-yeterday/m-p/4601235#M12264 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/924212">@JSmart913</a>&nbsp;Several ways to do this. One would be to add this column to your data and then set a page or report level filter to filter for 1:</P> <P>&nbsp;</P> <LI-CODE lang="markup">Column = IF( [Date] &lt; TODAY(), 1, 0 )</LI-CODE> <P>This assumes that the data is refreshed every morning for example.</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 07 Mar 2025 22:28:50 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Filtering-data-through-yeterday/m-p/4601235#M12264 Greg_Deckler 2025-03-07T22:28:50Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Filtering-data-through-yeterday/m-p/4607167#M12299 <P>Thank you!&nbsp; Is there a way to do it on the visual level instead of adding to the dataset?</P> Wed, 12 Mar 2025 14:59:30 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Filtering-data-through-yeterday/m-p/4607167#M12299 JSmart913 2025-03-12T14:59:30Z