Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi, yes!!!! I would like each price to be represented by a separate Dot and that they each coloured by project.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |