Forum Discussion

fanhui3's avatar
fanhui3
Icon for Helper I rankHelper I
5 years ago

How to prevent aggregation of data point in scattered plot

Hi, 

 

I am facing issue with my scattered plot. PowerBI aggregates my data point (see circled in grey) instead of giving my separate plot on the graph (see circled in red in the top tip and on the y axis). Anyone has a solution to this? I will enclose a dropbox link to the pbix file below if you want to test out your solution. Thank you. 

 

https://www.dropbox.com/s/z3jg236jmu6vugv/Price%20Analyser%20-%20Request%20help.pbix?dl=0

 

  

General Comment
Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi fanhui3 ,

     

    Believe that the issue you have here is the aggregation you are using on the legend, since you are grouping by projects it gives you a sum of all prices per square meter.

     

    What is the type of details you want? You want to present all prices but with colours by project?

    • fanhui3's avatar
      fanhui3
      Icon for Helper I rankHelper I
      5 years ago

      Hi, yes!!!! I would like each price to be represented by a separate Dot and that they each coloured by project.  

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi fanhui3 ,

     

    Sorry for that you can add date to the x-axis however it then sums the data points.

    Normally, the visuals in power bi will show the aggregate value except for table visual.

     

    Or you can create a calculate column and put it in legend.

     

    Column = 'Past Property Transaction Price'[Project Name]&"-"&'Past Property Transaction Price'[Price Per sqft]

     

     

    Perhaps you can refer this thread, hope it can inspire you.

    https://community.powerbi.com/t5/Desktop/Scatter-with-date-on-X-and-time-on-Y/td-p/19030

     

    Best regards,

     

    Community Support Team _ zhenbw

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