Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Scatter chart overlapping points (i.e. multiple points with the same X and Y values)

Hi All, I've hit a bit of a roadblock using the Scatter Chart within Power BI.  The issue is when multiple points have exactly the same X and Y values they are drawn on top of each other, but as the...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may follow steps below.

     

    1.Set field Achievement (x-axis) and Effort (y-axis) Default Summarization: Don't summarize .

     

    2.Create a measure like DAX below, and put it into Size box of the Scatter visual.

     

    Size Measure = IF(ISFILTERED(Table1[Student]),COUNTROWS(Table1),CALCULATE(COUNTROWS(Table1),ALL(Table1[Student])))

     

    3. Select on this Scatter visual, go to Format pane, turn on the option "Category".

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

karo's avatar
karo
Advocate V
3 years ago

newpi v-xicai I am facing similar issue. 

 

I do not see don't summarize option, when I use measures on X and Y axeses.  Even if I change measueres to fields and follow the steps, I am getting an error:

 

Error Message:
Remove Values to display x- and y-axis pairs. Alternatively, you can keep Values and set a summarization for x- and y-axis.

 

Any hints? 

 

Regards,

Karo