Forum Discussion
Exclude null date only when 'between' range is selected
I have a table similar to this
and a date slicer
What I want is that when a date slicer is applied like in this case the table should display only two rows '23 Feb' and '26 Feb'. Not the other two rows where the started at is null. However when no date filter is applied the table should be the complete table including all the null dates like this
Here is the pbix file
IsFiltered = IF(ISFILTERED('Table'[Started at]) && ISBLANK(SELECTEDVALUE('Table'[Started at])),0,1)Create a measure like this and apply filter on the table to see only values where IsFiltered is 1.
When no filters:
With filters:
5 Replies
Hi,
you can use https://wetransfer.com/ and share a link with pbix file. 🙂 It will be easier to help you with this challenge.IsFiltered = IF(ISFILTERED('Table'[Started at]) && ISBLANK(SELECTEDVALUE('Table'[Started at])),0,1)Create a measure like this and apply filter on the table to see only values where IsFiltered is 1.
When no filters:
With filters: