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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
STIBBS_807
Resolver I
Resolver I

Get Data Before the Date in a slicer

I am struggling with how do I get my data in a Table Visual to show only data that is based on a slicer date.  So I put in the date, but I want all data that is before or on that date.  That is my start date.  Then I have an End Date, but I want that to be before or on that date or null.

 

Here is how I visualize the query for the data.

 

[Start Date] <= [Begin Date] and

([End Date] >= [Finish Date] or [End Date] = null)

 

How do I do that in Power BI Desktop?

1 REPLY 1
STIBBS_807
Resolver I
Resolver I

 I tried to use the date in the Table as a filter and used "is on or before" but I have to enter the date each time I use the report.  I was hoping the slicer could give me the date to fill the filter.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.