Showing data from second table if no values

[Anonymous]

Folks,

Found it difficult to give a decent subject, but hopefully someone will understand and be able to give me a solution for this.

I have a tbTimesheets , a tbEmployees (linked by employeeID to tbTimesheets) and a tbManagers (linked by employeeID to tbEmployees. I have created slicers that filters both timesheet period (tbTimesheet), employee (tbEmployee) and manager (tbManager). Then a table that shows employee (tbEmployees), timesheet period (tbTimesheets) and timesheet approval status (tbTimesheets).

All works fine, except that there may be employees that haven't created a timesheet for the week, hence no records in the filtered tbTimesheets record set. I really would like to see those as well.

Or put differently, how can I show all the filtered employees regardless if there are any timesheets?

Hope that makes sense 🙂

[v-huizhn-msft]

Hi @Anonymous,

In the visual fields area, please select employees->Show items with no data, and check if it works fine.



Best Regards,
Angelia