Relationships and Slicer

Hi Greg_Deckler

Sorry to bring you back to this topic but I've just realised my problem isn't fully resolved.

Only a small selection of departments are being sliced, and the rest are being lumped into a (blank) category when visualsied.

I've gone back to your first reply and when slicing by the DeptCode, the Payroll table with row_id dosen't slice correctly on all departments.

Thanks

Here's an updated screenshot: (Employee Master contains each employees current department in em_department)
Relationships w EM table