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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anders_G
Helper I
Helper I

Help with date filter to show rows that fall between two dates

Hi,

 

Let's say I have a dataset with three columns as shown below. I want to be able to tell which of the projects were running on a specific date. For example. I'm being asked to show all projects that were active on February 7th, 2023. Which would be Project #1-2.

 

(For other dashboards I have created a line for each date that falls within the start and end dates. But, that won't work this time as I have too much data and the dashboard would exceed the 1GB limit with the additional lines.)

 

Thank you!

 

ProjectStart DateEnd Date
12023-01-012023-02-28
22023-02-012023-04-30
32023-03-012023-05-31
1 ACCEPTED SOLUTION
ray_aramburo
Super User
Super User

Add 2 slicer visuals:

One for Start Date, set it up as an "After" type in the slicer settings, another one for End Date and set it up as "Before" type.

Then you can manually change the dates from both slicers. 

ray_aramburo_0-1687362001895.pngray_aramburo_1-1687362085046.png

 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
ray_aramburo
Super User
Super User

Add 2 slicer visuals:

One for Start Date, set it up as an "After" type in the slicer settings, another one for End Date and set it up as "Before" type.

Then you can manually change the dates from both slicers. 

ray_aramburo_0-1687362001895.pngray_aramburo_1-1687362085046.png

 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors