Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
@Anonymous
then you shuld unselect the regional manager
Proud to be a Super User!
</> 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?
@Anonymous
Just Add only employee Data into Table
Add two slicers 1. Direct manager 2. Regional manager
thats it!
Proud to be a Super User!
</>
but still we need Manager Data into table..as if they select their name indvidually to see the status
@Anonymous
I think a sample data will give better idea. Is that Data is in single columns or multiple columns?!
Proud to be a Super User!
</>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 |
@Anonymous
Check this file and let me know if it answers your question. Share your Kudoes
Proud to be a Super User!
</>
When i select Peter, In table/Chart Peter should not come.
</> what was done in this? i know its bit tricky..looking at file it looks everything straightforward.
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |