Forum Discussion
Showing data from second table if no values
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 :)
1 Reply
- v-huizhn-msftMicrosoft Employee
Hi Anonymous,
In the visual fields area, please select employees->Show items with no data, and check if it works fine.
Best Regards,
Angelia