Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
75 | |
65 | |
51 | |
36 |
User | Count |
---|---|
112 | |
91 | |
80 | |
62 | |
40 |