Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a date range like this
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
but the result I am getting is
and the course count is 4 as well, where as it should be 2.
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"
I hope I answered your question Please give Kudos and accept it as a solution.
Thanks!
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.
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.
Hi @Uzi2019 I have updated the post, it's just one table with all the information in it
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |