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 d...
  • 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.