Forum Discussion
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
| 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"
- Anonymous1 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 TeamIf 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
- quantumudit
Super User
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
- AnonymousNot applicable
hi quantumudit , sorry. i have updated my post. thanks for your response
- powerbidev123
Solution Sage
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'.
- AnonymousNot applicable
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:
- AnonymousNot applicable
Hi, Anonymous
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