Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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-msft's avatar
    v-huizhn-msft
    Microsoft 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