Data Suppression After Drill Down in Visual

Question

Hello,I am trying to apply data suppression on a 100% column chart based on a management hierarchy. I have a table of employees, their employee type, their manager, and the manager by hierarchy level. Ideally, at the top level, all data is displayed, however after the user drills down, if there is only an employee with no direct reports, their data is suppressed. I'm attaching a sample of the table below.Employee NameManager NameEmployee TypeManager Level 1Manager Level 2Manager Level 3Employee 1&nbsp;AEmployee 1&nbsp;&nbsp;Employee 2Employee 1BEmployee 1Employee 2&nbsp;Employee 3Employee 1BEmployee 1Employee 3&nbsp;Employee 4Employee 1BEmployee 1Employee 4&nbsp;Employee 5Employee 1AEmployee 1Employee 5&nbsp;Employee 6Employee 2AEmployee 1Employee 2Employee 6Employee 7Employee 2BEmployee 1Employee 2Employee 7Employee 8Employee 2AEmployee 1Employee 2Employee 8Employee 9Employee 3BEmployee 1Employee 3Employee 9Employee 10Employee 3AEmployee 1Employee 3Employee 10Employee 11Employee 4AEmployee 1Employee 4Employee 11I'm also attaching images of the intended behavior. At level 1, the data for all 11 employees is shown. After drilling down, two employees are excluded from the visual on the right(employee 5 and the blank corresponding to employee 1). I've tried using the IsInScope function to get the visual behavior I'm looking for.&nbsp;Any help would be appreciated!

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
I made a sample for you with IsInScope function.

Measure = SWITCH(TRUE(),
    ISINSCOPE(Table1[Manager Level 3]),IF(MAX(Table1[Manager Level 3]) IN FILTER( ALL('Table1'[Manager Name]),NOT(ISBLANK([Manager Name]))), COUNTROWS('Table1'),BLANK()), 
    ISINSCOPE(Table1[Manager Level 2]),IF(MAX(Table1[Manager Level 2]) IN FILTER( ALL('Table1'[Manager Name]),NOT(ISBLANK([Manager Name]))), COUNTROWS('Table1'),BLANK()), 
    ISINSCOPE(Table1[Manager Level 1]),COUNTROWS('Table1'))
&nbsp;
Best Regards,
Wearsky

Forum Discussion

Data Suppression After Drill Down in Visual

2 Replies

Related content

Authentication popup suppression in power query excel

Suppress (Hide) Zero Value in Matrix

Suppress 0 in Field Parameters

Suppressing data

Filtering out future dates while not suppressing zeros in visual

Employee Name	Manager Name	Employee Type	Manager Level 1	Manager Level 2	Manager Level 3
Employee 1		A	Employee 1
Employee 2	Employee 1	B	Employee 1	Employee 2
Employee 3	Employee 1	B	Employee 1	Employee 3
Employee 4	Employee 1	B	Employee 1	Employee 4
Employee 5	Employee 1	A	Employee 1	Employee 5
Employee 6	Employee 2	A	Employee 1	Employee 2	Employee 6
Employee 7	Employee 2	B	Employee 1	Employee 2	Employee 7
Employee 8	Employee 2	A	Employee 1	Employee 2	Employee 8
Employee 9	Employee 3	B	Employee 1	Employee 3	Employee 9
Employee 10	Employee 3	A	Employee 1	Employee 3	Employee 10
Employee 11	Employee 4	A	Employee 1	Employee 4	Employee 11