Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Yes, just take a look at Connect to SQL Server data.
Yes, just take a look at Connect to SQL Server data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |