Forum Discussion
Helper IScatter Plot With Month and Product ID
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
Super UserHi 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
Helper IJust 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
- rehansaeed2468
Yes I am expecting a chart like the first one with dots