Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to identify the outliers in a coworker's table. The table contains the number of calls a coworker accepted and the time he spent on the call (Handling time). I followed this video: https://www.youtube.com/watch?v=RoglNZ2dXW8&t=22s&ab_channel=EnterpriseDNA and built my Outlier Detection Logic. I defined my outlier criteria in there.
The problem is, once I add the scatter plot all coworkers appear as non-outliers and outliers at the same time, I created a table to see what's happening and I also saw the coworkers duplicated as outliers and non-outliers.
I've created a sample of the project, the PBXI sample data can be found here:
Any help or tips would be highly appreciated.
Solved! Go to Solution.
@Anonymous
You have duplicated value because no relationship can be created between the tables, since you used columns in both tables, power bi cannot determine which group does measure value belong.
Since you already found the outlier value 189 in this case, you can just create a new grouping column in the Coworker table, and use this new grouping as the legend and slicer.
@Anonymous
You have duplicated value because no relationship can be created between the tables, since you used columns in both tables, power bi cannot determine which group does measure value belong.
Since you already found the outlier value 189 in this case, you can just create a new grouping column in the Coworker table, and use this new grouping as the legend and slicer.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
49 | |
45 | |
20 | |
16 |