Forum Discussion
Power BI Scatter Graph help !!!!!!!!!!!!!!
I need help. I have a scatter graph in Power BI with several points that are overlapping specifically cohorts with a 5,5 points. To provide a bit of context, we are comparing employee performance throughout the year, and most people in the department have achieved a score of 5 for both behavior and achievement. Therefore, the X-axis represents behavior, and the Y-axis represents achievement. As a result, most of the points are located at (5,5). How can I resolve this issue in Power BI? Is there a DAX formula that can help?
Hi Bigshow ,
In PowerBI it is not allowed to have duplicate values in the Scatter chart, you can only show the corresponding view if the values are non-duplicates.
But I think you can create data close to these duplicate values to fulfill your needs.
Then I create two measures.
JitteredBehavior = MAX('Table'[Behavior]) + RAND() * 0.1 - 0.05JitteredAchievement = MAX('Table'[Achievement]) + RAND() * 0.1 - 0.05Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Bigshow ,
In PowerBI it is not allowed to have duplicate values in the Scatter chart, you can only show the corresponding view if the values are non-duplicates.
But I think you can create data close to these duplicate values to fulfill your needs.
Then I create two measures.
JitteredBehavior = MAX('Table'[Behavior]) + RAND() * 0.1 - 0.05JitteredAchievement = MAX('Table'[Achievement]) + RAND() * 0.1 - 0.05Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
