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've searched through the threads and haven't come across exactly what i'm after, or perhaps i'm not understanding the solutions clearly to be able to apply to my scenario.
Among other tables, I have an employee table and a sales table with sales data from 2019 onwards. The employee table contains thousands of employees some of which have left the company prior to 2019 hence wouldn't have any sales. When i add a slicer using EmpID from the Employee Details table, i don't want to see EmpIDs of those that i know have left and wouldn't have any sales values against their name.
Note as there are thousands of employees in the employee table, i'd be looking at removing about 60% of them from the slicer drop down so am looking for the easiest way to do this. Can i use a measure to apply as a filter?
What i have now:
What i want to have:
Sample File - Hide slicer values.pbix
Thanks in advance for any help!
This article explains how to use a measure as a visual filter for slicers:
https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/
Proud to be a Super User!
I am trying to apply:
however I am using a bridge table between 2 tables (Hire and Vacancy) and the bridge table has [Manager] field in it and I use this field in Manager Slicer. I do not want a mangers name to appear in the slicer IF the manager has no data on either the Hire or Vacancy table.
Appreciate any help here!
Dawn
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |