Forum Discussion

Bigshow's avatar
Bigshow
New Member
1 year ago
Solved

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 thr...
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.05
    JitteredAchievement = MAX('Table'[Achievement]) + RAND() * 0.1 - 0.05

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.05
JitteredAchievement = MAX('Table'[Achievement]) + RAND() * 0.1 - 0.05

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.