Scatter Plot - Need Help With Date on X-Axis and Data Summing

Question

I am trying to create a simple scatter plot that will eventually include a large amount of data that I can use to easily spot trends. I would like to display field values for two different and distinct test types (OV / QA) over a period of time. I do not encounter any problems unless field values fall on the same date - then the values sum together. I need these three things to work together: date on X Axis, (non-manipulated) data on Y Axis, two easily distinguishable sets of data without summation.&nbsp;Here are troubleshooting tips I have tried:Try:&nbsp;Put Field Value in Y Axis, Test Date in X Axis, and Test Type in Legend. Result: Delineates between data as needed to spot varying trends, but summarizes all data that occurs on same day.Try: Added an index to the data set and removed "summarize" on Field Values. Result: Does not work with a date in the X Axis.&nbsp;Try: Separated out the results from the data sets to add in two different types of data on the Y Axis. Result: Can only add one data set to Y Axis.Try: Put Values in Y Axis, Test Date in X Axis, and Index in Legend. Result: Too much data to show all of the results and every dot is a different color - no way to distinguish between two data sets.Could someone please provide help? I also use slicers to drill down on time frames and Field Name/Table Name. Those seem to work fine. I have attached a sample set of data below.&nbsp;Thank you!&nbsp;

v-piga-msft · Answer

Hi&nbsp;jecochran&nbsp;,
If it is convenient, please always show your sample data in text-tabular format in addition to (or&nbsp;instead of)&nbsp; screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).
Best Regards,
Cherry
&nbsp;

jecochran · Answer

Thank you&nbsp;v-piga-msft! I appreciate all of the help I can get. I would like to keep the .pbix file internal if possible, but I have added a copy of the table below.&nbsp;Sample IDTable NameField NameTest TypeField ValueTest DateIDFieldIndexOVQA408tbl AsphaltMixBase1 1/2|Percent PassingQA94.7002/07/19408 1 1/2|Percent Passing150&nbsp;94.70408tbl AsphaltMixBase1|Percent PassingQA91.1702/07/19408 1|Percent Passing151&nbsp;91.17408tbl AsphaltMixBase2|Percent PassingQA10002/07/19408 2|Percent Passing152&nbsp;100409tbl AsphaltMixBase#200|Percent PassingQA5.4402/07/19409 #200|Percent Passing153&nbsp;5.44409tbl AsphaltMixBase#8|Percent PassingQA31.2302/07/19409 #8|Percent Passing154&nbsp;31.23409tbl AsphaltMixBase1 1/2|Percent PassingQA94.2602/07/19409 1 1/2|Percent Passing155&nbsp;94.26409tbl AsphaltMixBase1|Percent PassingQA88.5302/07/19409 1|Percent Passing156&nbsp;88.53409tbl AsphaltMixBase2|Percent PassingQA10002/07/19409 2|Percent Passing157&nbsp;100410tbl AsphaltMixBase#200|Percent PassingQA4.7002/07/19410 #200|Percent Passing158&nbsp;4.70410tbl AsphaltMixBase#8|Percent PassingQA23.5202/07/19410 #8|Percent Passing159&nbsp;23.52410tbl AsphaltMixBase1 1/2|Percent PassingQA97.0502/07/19410 1 1/2|Percent Passing160&nbsp;97.05410tbl AsphaltMixBase1|Percent PassingQA76.4702/07/19410 1|Percent Passing161&nbsp;76.47410tbl AsphaltMixBase2|Percent PassingQA10002/07/19410 2|Percent Passing162&nbsp;100411tbl AsphaltMixBase#200|Percent PassingQA6.2502/07/19411 #200|Percent Passing163&nbsp;6.25411tbl AsphaltMixBase#8|Percent PassingQA43.7502/07/19411 #8|Percent Passing164&nbsp;43.75411tbl AsphaltMixBase1 1/2|Percent PassingQA94.37502/07/19411 1 1/2|Percent Passing165&nbsp;94.375411tbl AsphaltMixBase1|Percent PassingQA92.502/07/19411 1|Percent Passing166&nbsp;92.5411tbl AsphaltMixBase2|Percent PassingQA10002/07/19411 2|Percent Passing167&nbsp;100412tbl AsphaltMixBase#200|Percent PassingOV11.7602/07/19412 #200|Percent Passing16811.76&nbsp;412tbl AsphaltMixBase#8|Percent PassingOV44.1102/07/19412 #8|Percent Passing16944.11&nbsp;412tbl AsphaltMixBase1 1/2|Percent PassingOV94.7002/07/19412 1 1/2|Percent Passing17094.70&nbsp;412tbl AsphaltMixBase1|Percent PassingOV82.3502/07/19412 1|Percent Passing17182.35&nbsp;412tbl AsphaltMixBase2|Percent PassingOV10002/07/19412 2|Percent Passing172100&nbsp;&nbsp;

v-piga-msft · Answer

Hi&nbsp;jecochran&nbsp;,
Thanks for your data sample firstly.
By my tests and research, I'm afraid that we cannot achieve your desired output in the bubble chart as it always show the aggregate value.
Normally, the visuals in power bi will show the aggregate value except for table visual.
Best&nbsp; Regards,
Cherry
&nbsp;

Forum Discussion

Related content

Scatter Plot X-Axis Date Issue

dynamic x-axis based on filter

X axis sort in scatter chart

Congested X-Axis Range

Scatter chart X axis sorting issue