Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Plot unsummarized data on x and y chart

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

A10Monday, November 11, 20241
A101Monday, November 11, 20242
A10Monday, November 11, 20243
A23Monday, November 11, 20244
A4Monday, November 11, 20245
A23Monday, November 11, 20246
A543Monday, November 11, 20247
A31Monday, November 11, 20248
A653Monday, November 11, 20249
A234Monday, November 11, 202410
A23Monday, November 11, 202411
A645Monday, November 11, 202412
A67Monday, November 11, 202413
A34Monday, November 11, 202414
A65Monday, November 11, 202415
A123Monday, November 11, 202416
A78Monday, November 11, 202417
A97Monday, November 11, 202418
A23Monday, November 11, 202419
A45Monday, November 11, 202420
A67Monday, November 11, 202421
A9Monday, November 11, 202422
A7342Monday, November 11, 202423
A56Monday, November 11, 202424
A865Monday, November 11, 202425
A123Monday, November 11, 202426
A54Monday, November 11, 202427
A76Monday, November 11, 202428
A87Monday, November 11, 202429
A3543Monday, November 11, 202430
B12Monday, November 11, 202431
B45Monday, November 11, 202432
B67Monday, November 11, 202433
B78Monday, November 11, 202434
B34Monday, November 11, 202435
B12Monday, November 11, 202436
B5Monday, November 11, 202437
B67Monday, November 11, 202438
B34Monday, November 11, 202439
B12Monday, November 11, 202440
B43Monday, November 11, 202441
B54Monday, November 11, 202442
B67Monday, November 11, 202443
B78Monday, November 11, 202444
B89Monday, November 11, 202445
B754Monday, November 11, 202446
B0Monday, November 11, 202447
B23Monday, November 11, 202448
B54Monday, November 11, 202449
B23Monday, November 11, 202450
B6Monday, November 11, 202451
B7Monday, November 11, 202452
B453Monday, November 11, 202453
B2Monday, November 11, 202454
B3Monday, November 11, 202455
B6Monday, November 11, 202456
B43Monday, November 11, 202457
B23Monday, November 11, 202458
B12Monday, November 11, 202459
B34Monday, November 11, 202460
C46Monday, November 11, 202461
C67Monday, November 11, 202462
C87Monday, November 11, 202463
C98Monday, November 11, 202464
C46Monday, November 11, 202465
C534Monday, November 11, 202466
C23Monday, November 11, 202467
C12Monday, November 11, 202468
C34Monday, November 11, 202469
C45Monday, November 11, 202470
C23Monday, November 11, 202471
C45Monday, November 11, 202472
C67Monday, November 11, 202473
C8Monday, November 11, 202474
C78Monday, November 11, 202475
C56Monday, November 11, 202476
C34Monday, November 11, 202477
C2Monday, November 11, 202478
C5Monday, November 11, 202479
C467Monday, November 11, 202480
C78Monday, November 11, 202481
C45Monday, November 11, 202482
C23Monday, November 11, 202483
C65Monday, November 11, 202484
C34Monday, November 11, 202485
C7864Monday, November 11, 202486
C5Monday, November 11, 202487
C23Monday, November 11, 202488
C45Monday, November 11, 202489
C67Monday, November 11, 202490

 

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"

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Anonymous 

    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

8 Replies

  • Hello Anonymous 

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

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

  • Hey Anonymous , 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'.