Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to exclude a data from the chart and table

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.

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

     

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
    VijayP
    Community Champion
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      </>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. NoEmployee NameDirect ManagerRegional ManagerTask Name Start DateCompletion DateStatus
      1SamPeterRobDevelopment Review101.01.2131.12.21Complete
      2MaryPeterRobDevelopment Review201.01.2231.12.22In Progress
      3JuliePeterRobDevelopment Review301.01.2131.12.21Complete
      4PeterPeterRobDevelopment Review401.01.2131.12.21Complete
      5RobRobRobFinal Review31.12.2131.12.21Complete
      6AlexJeffJimTest Review 101.01.2131.12.21Complete
      7KarenJeffJimTest Review 201.01.2131.12.22In Progress
      8SteveJeffJimTest Review 301.01.2131.12.21Complete
      9GeorgeJeffJimTest Review 401.01.2131.12.21Complete
      10JimJimJimFinal Test Review31.12.2131.12.21Complete
  • VijayP's avatar
    VijayP
    Community Champion
    4 years ago

    Anonymous 

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

     thats it! 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      </>

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

  • VijayP's avatar
    VijayP
    Community Champion
    4 years ago

    Anonymous 

    then you shuld unselect the regional manager 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      </> 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?