Dynamic Slicer Content

[mseppanen]

I have a Slicer for a report that contains Employees in a Department, my Employees are defined in a table in my ERP system (SQL DB).

We gain and lose employees, and they move between departments on a fairly regular basis.

Is it possible to tie the Content of the Slicer for Department to the Employee Table in my SQL Table?

Or am I doomed to do busy work and update the Slicers manually every time an Employee has a change?

Example:

Panel Saws: Susan, Billy, Martin

Shipping: George, Mark, John

Mark moves to Panel Saws, and we hire Chris for Shipping.

Panel Saws: Susan, Billy, Martin, Mark

Shipping: George, John, Chris

Ideally the Report Slicer would be updated and the Report would show only the employees in the respective departments, without having to redefine the Contents each time.

[v-chuncz-msft · Accepted solution]

@mseppanen ,

Yes, just take a look at Connect to SQL Server data.