How to exclude a data from the chart and table

[Anonymous]

I have a slicer and associated chart and table. Table consists of employee and their direct manager and regional manager. If I select the one of the direct manager from the slicer, the chart should data of his employees.But currently my chart shows both his and his employee details. How to exclude the direct manager data from the chart/Table.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please have a try.

Flag = if(SELECTEDVALUE('Table'[Employee Name]) in ALLSELECTED('Table'[Direct Manager]),0,1)

Then filter the data.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VijayP]

@Anonymous 

then you shuld unselect the regional manager 

[Anonymous]

</> Thats not possible, requirement itself is like that, first you need to select RM and then Direct Manager and see the data. Is there any way?

[VijayP]

@Anonymous 

Just Add only employee Data into Table
Add two slicers 1. Direct manager 2. Regional manager

 thats it! 

[Anonymous]

</>

but still we need Manager Data into table..as if they select their name indvidually to see the status

[VijayP]

@Anonymous 
I think a sample data will give better idea. Is that Data is in single columns or multiple columns?!

[Anonymous]

</>Please find the sample data..

If i select Regional Manager - Chart/Table should show all the employees data reporting to Regional Mangager

Ex: if select Rob - All data related to Direct Manager and Employee should show

If i select any of Direct Manager - say Peter, it should his reportees data only ,it should not show Peter Data

SL. No	Employee Name	Direct Manager	Regional Manager	Task Name	Start Date	Completion Date	Status
1	Sam	Peter	Rob	Development Review1	01.01.21	31.12.21	Complete
2	Mary	Peter	Rob	Development Review2	01.01.22	31.12.22	In Progress
3	Julie	Peter	Rob	Development Review3	01.01.21	31.12.21	Complete
4	Peter	Peter	Rob	Development Review4	01.01.21	31.12.21	Complete
5	Rob	Rob	Rob	Final Review	31.12.21	31.12.21	Complete
6	Alex	Jeff	Jim	Test Review 1	01.01.21	31.12.21	Complete
7	Karen	Jeff	Jim	Test Review 2	01.01.21	31.12.22	In Progress
8	Steve	Jeff	Jim	Test Review 3	01.01.21	31.12.21	Complete
9	George	Jeff	Jim	Test Review 4	01.01.21	31.12.21	Complete
10	Jim	Jim	Jim	Final Test Review	31.12.21	31.12.21	Complete

[VijayP]

@Anonymous 
Check this file and let me know if it answers your question. Share your Kudoes

[Anonymous]

</>

When i select Peter, In table/Chart Peter should not come.

[Anonymous]

</> what was done in this? i know its bit tricky..looking at file it looks everything straightforward.