Plot unsummarized data on x and y chart

[junmin]

x axis is product ID

y axis is every transaction of the sale of product

so for one product ID, there will be multiple vertical dots

i was able to create index and put it in the Values field to create the multiple vertical dots but i cannot do it when the x and y are not summarized. i need x and y axis to not be summarized.

UPDATE:

i managed to create the plot but it gives me error 't

oo many index values'. Index is my row ID

This is what i have now but i am expecting all the other x value having dots as well.

This is what i input:

UPDATE 2:

Example data:

ProductID | Sales | Date | Index

A	10	Monday, November 11, 2024	1
A	101	Monday, November 11, 2024	2
A	10	Monday, November 11, 2024	3
A	23	Monday, November 11, 2024	4
A	4	Monday, November 11, 2024	5
A	23	Monday, November 11, 2024	6
A	543	Monday, November 11, 2024	7
A	31	Monday, November 11, 2024	8
A	653	Monday, November 11, 2024	9
A	234	Monday, November 11, 2024	10
A	23	Monday, November 11, 2024	11
A	645	Monday, November 11, 2024	12
A	67	Monday, November 11, 2024	13
A	34	Monday, November 11, 2024	14
A	65	Monday, November 11, 2024	15
A	123	Monday, November 11, 2024	16
A	78	Monday, November 11, 2024	17
A	97	Monday, November 11, 2024	18
A	23	Monday, November 11, 2024	19
A	45	Monday, November 11, 2024	20
A	67	Monday, November 11, 2024	21
A	9	Monday, November 11, 2024	22
A	7342	Monday, November 11, 2024	23
A	56	Monday, November 11, 2024	24
A	865	Monday, November 11, 2024	25
A	123	Monday, November 11, 2024	26
A	54	Monday, November 11, 2024	27
A	76	Monday, November 11, 2024	28
A	87	Monday, November 11, 2024	29
A	3543	Monday, November 11, 2024	30
B	12	Monday, November 11, 2024	31
B	45	Monday, November 11, 2024	32
B	67	Monday, November 11, 2024	33
B	78	Monday, November 11, 2024	34
B	34	Monday, November 11, 2024	35
B	12	Monday, November 11, 2024	36
B	5	Monday, November 11, 2024	37
B	67	Monday, November 11, 2024	38
B	34	Monday, November 11, 2024	39
B	12	Monday, November 11, 2024	40
B	43	Monday, November 11, 2024	41
B	54	Monday, November 11, 2024	42
B	67	Monday, November 11, 2024	43
B	78	Monday, November 11, 2024	44
B	89	Monday, November 11, 2024	45
B	754	Monday, November 11, 2024	46
B	0	Monday, November 11, 2024	47
B	23	Monday, November 11, 2024	48
B	54	Monday, November 11, 2024	49
B	23	Monday, November 11, 2024	50
B	6	Monday, November 11, 2024	51
B	7	Monday, November 11, 2024	52
B	453	Monday, November 11, 2024	53
B	2	Monday, November 11, 2024	54
B	3	Monday, November 11, 2024	55
B	6	Monday, November 11, 2024	56
B	43	Monday, November 11, 2024	57
B	23	Monday, November 11, 2024	58
B	12	Monday, November 11, 2024	59
B	34	Monday, November 11, 2024	60
C	46	Monday, November 11, 2024	61
C	67	Monday, November 11, 2024	62
C	87	Monday, November 11, 2024	63
C	98	Monday, November 11, 2024	64
C	46	Monday, November 11, 2024	65
C	534	Monday, November 11, 2024	66
C	23	Monday, November 11, 2024	67
C	12	Monday, November 11, 2024	68
C	34	Monday, November 11, 2024	69
C	45	Monday, November 11, 2024	70
C	23	Monday, November 11, 2024	71
C	45	Monday, November 11, 2024	72
C	67	Monday, November 11, 2024	73
C	8	Monday, November 11, 2024	74
C	78	Monday, November 11, 2024	75
C	56	Monday, November 11, 2024	76
C	34	Monday, November 11, 2024	77
C	2	Monday, November 11, 2024	78
C	5	Monday, November 11, 2024	79
C	467	Monday, November 11, 2024	80
C	78	Monday, November 11, 2024	81
C	45	Monday, November 11, 2024	82
C	23	Monday, November 11, 2024	83
C	65	Monday, November 11, 2024	84
C	34	Monday, November 11, 2024	85
C	7864	Monday, November 11, 2024	86
C	5	Monday, November 11, 2024	87
C	23	Monday, November 11, 2024	88
C	45	Monday, November 11, 2024	89
C	67	Monday, November 11, 2024	90

This is what i got now and it is what i want as well. but it is not showing all the products. based on screenshot below, product ID C is not seen. and the error facing is as what i mentioned above. "too many index"

[powerbidev123]

Hey @junmin , Try to put the Sales value in the Values field and in the size field keep your index. In your y-axis set the max of sales as 'Dont summarize'. 

[junmin]

hi @powerbidev123 , do you mean like this? the Values field is my Sales, x axis is my product ID, y axis is my Sales, Size is sum of index.

compulsory to aggregate the Size field:

unfortunately, this leads to this error:

[Anonymous]

Hi, @junmin 

Thanks for all replies. You can share the pbix files without sensitive data for testing purposes, which will help you solve the problem faster. Feel free to help you.

Here are some notes:
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Best Regards,
Yang
Community Support Team

[junmin]

hi @Anonymous , i updated my post to include the dummy data table and the result i have and expecting

[Anonymous · Accepted solution]

Hi, @junmin 

After testing, the maximum number of Legends supported by the current version of the PBI scatter chart appears to be 60 and below. You can try to use Bubble Chart with Categorical Data (Pro) / Dual Axis Scatter Chart (Pro), those visual objects can meet your needs and you have 30 days free trial time.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[junmin]

thank you for your help @Anonymous 

[quantumudit]

Hello @junmin 

Please provide a detailed description of the problem you're encountering. If it concerns summarization alone, you can disable this feature by right-clicking on the field name. However, if there are additional issues, please inform us.

Thanks

Udit

[junmin]

hi @quantumudit , sorry. i have updated my post. thanks for your response