selector slicer not filtering matrix table

[Anonymous]

Hi Experts

See atatched sample PBIX,

I cannot see my error i need the selector slicer to filter the matrix table and show missing timesheet based on the selection made from the slicer. So if 1 is selected then only show data relating to where the total is 1 in the matrix table

Sample PBIX

https://www.dropbox.com/s/zijkx7ucsxcds9l/SampleFile_.pbix?dl=0  

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download sample PBIX file

You need to create a slicer from the Status in the FCATData table.  You can then filter the matrix as you wish

Regards

Phil