Forum Discussion
Helper IScatter Plot With Month and Product ID
I have a requirement where I am using the Scatter Plot with MOnth Year filed (MMM-YYYY) on X-Axis and Sum Sales on Y Axis.
My table has Product Id, Date and Sales columns, I would like to show MOnth Year field on XAxis and also would like to see the Bubbles for all the Product IDs during that month.
Here is the sample data set I used in the sample PBIX file that can be downloaded at the below location.
https://drive.google.com/file/d/1zl3wf7e6lzNluq9djNNI8JabGziO-yBl/view?usp=sharing
| Product ID | Order Date | Sales |
| M1 | 1/1/2025 | 50 |
| M2 | 1/1/2025 | 20 |
| M3 | 1/10/2025 | 30 |
| M4 | 1/10/2025 | 10 |
| M5 | 2/15/2025 | 5 |
| M6 | 2/15/2025 | 60 |
| M7 | 2/20/2025 | 30 |
Hi rehansaeed2468,
In a Power BI scatter chart, this behavior is expected because the visual can split bubbles by either Legend or Details, not both. Since Shop ID is already used in the Legend, all products for the same month and shop get grouped into one bubble. To show separate bubbles for each Product ID in the same month, you must place Product ID in the Details field. Keep Month Year on the X-axis (set to Continuous), Sum of Sales on the Y-axis, Shop ID in Legend, and Product ID in Details. This will create multiple bubbles at the same month one per product colored by shop. This is a built in limitation of the scatter visual in Power BI.
Thanks & Regards,
Prasanna Kumar
11 Replies
Hans-Georg_PulsSuper User
Hi rehansaeed2468 ,
to get the sum of sales separated by product assign "Product ID" to the Legend. Does that already meet your requirements?
rehansaeed2468Sorry I missed one more requirement. Each product has a ShoP Id too which is used in the Legend so cant use the Product ID in the Legend.
- cengizhanarslan
Simply, you could use ProductID to be used as "Legend" in you Scatter Chart if I understand you correctly.
- Hans-Georg_Puls
Hi rehansaeed2468 ,
if I understand you right, your requirements are:
- Month Year as x-axis (done?)
- Sum of Sales as y-Axis (done?)
- Shop Id as Legend (a data point for every Shop by Month Year, do you have some sample data including that Shop Id?, but should be done as well)
- But, what exactly do you mean by "I would like to see the Bubbles for all the Product IDs"
Possible options would be
- Use tooltips to show product ID and/or Shop ID
- Use colors to identidy Shops or Products
- The size of the bubbles is still available as an additional dimension
- rehansaeed2468
Just uploaded the updated data file with Shop ID.
- Month Year as x-axis (done?) Yes
- Sum of Sales as y-Axis (done?) Yes
- Shop Id as Legend (a data point for every Shop by Month Year, do you have some sample data including that Shop Id?, but should be done as well) Yes need Ship ID as Legend
- But, what exactly do you mean by "I would like to see the Bubbles for all the Product IDs" Would like to see Sales by Shop and By Product ID
- Hans-Georg_Puls
Hi rehansaeed2468,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to rehansaeed2468 and cengizhanarslan for prompt and helpful responses.
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar- Ashish_Mathur
Hi,
A scatter plot should have numerical fields on both axis
Hi rehansaeed2468,
In a Power BI scatter chart, this behavior is expected because the visual can split bubbles by either Legend or Details, not both. Since Shop ID is already used in the Legend, all products for the same month and shop get grouped into one bubble. To show separate bubbles for each Product ID in the same month, you must place Product ID in the Details field. Keep Month Year on the X-axis (set to Continuous), Sum of Sales on the Y-axis, Shop ID in Legend, and Product ID in Details. This will create multiple bubbles at the same month one per product colored by shop. This is a built in limitation of the scatter visual in Power BI.
Thanks & Regards,
Prasanna Kumar
Hi rehansaeed2468,
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar
