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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Exclude records where date is null when filtering by date range

I have a date range like this 

aqsa31_0-1697444084834.png

I want to see the list of all courses (in a matrix table with information like Course, Email, Assigned at, Started at etc ) that were started within that specific time frame but the issue is when I apply the dates the table and the matrix also display the rows where the started at is null, how can I make sure that the filtering is being done right? I have multiple date columns in my table (Around 3) that I am using as a filter 

 

PS: I want the rows with the null dates (started at and other dates) in the table, just not when a filter is applied 

 

For the selected date range as shown above 

 

the result should be 

aqsa31_2-1697444949889.png

aqsa31_0-1697444906986.png

but the result I am getting is 

aqsa31_1-1697444927199.png

 

and the course count is 4 as well, where as it should be 2. 

 

 

 

4 REPLIES 4
Uzi2019
Super User
Super User

Hi @Anonymous 
You can simply select all then uncheck the blank box like below under filter on visual.
" In your case please select the date in visual filter"

Uzi2019_0-1697451915868.png
I hope I answered your question Please give Kudos and accept it as a solution.
Thanks!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Anonymous
Not applicable

You missed this point 

 

"PS: I want the rows with the null dates (started at and other dates) in the table, just not when a filter is applied"

 

I want those rows in the table just not when a date filter is applied like in this case 'Started at'. So when no date range is selected the table SHOULD have the rows where any date is null as well. 

Uzi2019
Super User
Super User

Hi @Anonymous 
can you give proper input and output screnshot?
what exacty do you want?
how many tables and filter are there? how they are related. Give proper example.It would be easier for us to understand you requirements.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Anonymous
Not applicable

Hi @Uzi2019 I have updated the post, it's just one table with all the information in it 

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.