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.

v-xicai's avatar
v-xicai
Community Support
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.

  • newpi's avatar
    newpi
    Helper V
    6 years ago

    hi v-xicai 

    I;m facing the same issue. I can't see dont summarize option on my x and y axis probably because both these values are measures for me. What would be the best work around?