Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Scatter chart, duplicate values. How to show them?

Hello,

 

I have a scatter chart which holds coordinates X and Y, on it i have unique items with their own ID's i'd like to show. However, if two different items have the same X and Y it only shows one of them. Is there any way to avoid this problem and show both of the items?

 

Screenshot of the chart and its table:

https://gyazo.com/2ba0d1a5713223513d54fe13528720fa

 

Thank you in advance

 

 

Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    So like one on top of the other but smaller or like the circle split down the middle or?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      A split circle would be great if it'd still split it in case of there being more(5,6....) of the same values.

      • mahoneypat's avatar
        mahoneypat
        Icon for Microsoft Employee rankMicrosoft Employee
        6 years ago

        How about using size or doing expression based formatting, using count of rows with same X and Y value?

         

        If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

        Regards,

        Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    It's best to use color saturation for showing density of points. The density would be correlated with the number of points at the location of interest.

    Also, in R there are plots that add random jitter to points that are at the same location. I don't think this is available in PBI visuals but you could use R or Python to create such jittering plots.

    Best
    D