How to visualize rows with null values of dates in a selected dynamic date range

[deb_power123]

Hi Everyone,

There is a scenario as explained below.I have a student table with column names as below:-

1. StudentID
2. StudentName
3. LastAttendanceDate
4. StudentType

Below is my input excel file data :-

StudentID	StudentName	LastAttendanceDate	StudentType
100	Mary	02-05-2011 10:45	Fulltime
100	Mary		Fulltime
100	Mary	04-05-2011 12:45	Fulltime
100	Mary	06-05-2011 15:45	Fulltime
100	Mary		Fulltime
100	Mary	08-05-2011 19:45	Fulltime
100	Mary	09-05-2011 12:45	Fulltime
101	John	02-05-2011 10:45	Part Time
101	John	03-05-2011 11:23	Part Time
101	John	04-05-2011 10:45	Part Time
101	John	06-05-2011 15:49	Part Time
101	John		Part Time
101	John	08-05-2011 19:45	Part Time
101	John	09-05-2011 12:45	Part Time

In my visualization,I have a date slicer as shown below where I can set dynamic minimum and maximum date ranges to diplay the rows in a table visualization.

Is it feasible for us to select the date ranges in dateslicer and display the rows where the values of  Dates in the  Last AttendanceDate column are set to null?

Expected Output:

For example : In date range 06-05-2011 to 09-05-2011 as per the input data source above, there are two nulls so when we select this date ranges  06-05-2011 to 09-05-2011 in date slicer, it should return the rows as under:-

100	Mary		Fulltime
101	John		Part Time

while if we select the date range in slicer visualization from 02-05-2011 to 08-05-2011 then it should return the three rows as stated below:-

100	Mary		Fulltime
100	Mary		Fulltime
101	John		Part Time

Is there a possiblity to get these rows with null values of the date ranges and display on table visualization on dynamic selection of the date slicer?

Any possible DAX to handle this?

Please suggest your thoughts, truly appreciate for all your inputs.

Kind regards,

Sameer

[Pragati11]

Hi @deb_power123 ,

Have you tried using the option to "Show items with no data" ?

Thanks,

Pragati