Forum Discussion
Scatter Plot - Need Help With Date on X-Axis and Data Summing
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 distin...
Thank you 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.
| Sample ID | Table Name | Field Name | Test Type | Field Value | Test Date | IDField | Index | OV | QA |
| 408 | tbl AsphaltMixBase | 1 1/2|Percent Passing | QA | 94.70 | 02/07/19 | 408 1 1/2|Percent Passing | 150 | 94.70 | |
| 408 | tbl AsphaltMixBase | 1|Percent Passing | QA | 91.17 | 02/07/19 | 408 1|Percent Passing | 151 | 91.17 | |
| 408 | tbl AsphaltMixBase | 2|Percent Passing | QA | 100 | 02/07/19 | 408 2|Percent Passing | 152 | 100 | |
| 409 | tbl AsphaltMixBase | #200|Percent Passing | QA | 5.44 | 02/07/19 | 409 #200|Percent Passing | 153 | 5.44 | |
| 409 | tbl AsphaltMixBase | #8|Percent Passing | QA | 31.23 | 02/07/19 | 409 #8|Percent Passing | 154 | 31.23 | |
| 409 | tbl AsphaltMixBase | 1 1/2|Percent Passing | QA | 94.26 | 02/07/19 | 409 1 1/2|Percent Passing | 155 | 94.26 | |
| 409 | tbl AsphaltMixBase | 1|Percent Passing | QA | 88.53 | 02/07/19 | 409 1|Percent Passing | 156 | 88.53 | |
| 409 | tbl AsphaltMixBase | 2|Percent Passing | QA | 100 | 02/07/19 | 409 2|Percent Passing | 157 | 100 | |
| 410 | tbl AsphaltMixBase | #200|Percent Passing | QA | 4.70 | 02/07/19 | 410 #200|Percent Passing | 158 | 4.70 | |
| 410 | tbl AsphaltMixBase | #8|Percent Passing | QA | 23.52 | 02/07/19 | 410 #8|Percent Passing | 159 | 23.52 | |
| 410 | tbl AsphaltMixBase | 1 1/2|Percent Passing | QA | 97.05 | 02/07/19 | 410 1 1/2|Percent Passing | 160 | 97.05 | |
| 410 | tbl AsphaltMixBase | 1|Percent Passing | QA | 76.47 | 02/07/19 | 410 1|Percent Passing | 161 | 76.47 | |
| 410 | tbl AsphaltMixBase | 2|Percent Passing | QA | 100 | 02/07/19 | 410 2|Percent Passing | 162 | 100 | |
| 411 | tbl AsphaltMixBase | #200|Percent Passing | QA | 6.25 | 02/07/19 | 411 #200|Percent Passing | 163 | 6.25 | |
| 411 | tbl AsphaltMixBase | #8|Percent Passing | QA | 43.75 | 02/07/19 | 411 #8|Percent Passing | 164 | 43.75 | |
| 411 | tbl AsphaltMixBase | 1 1/2|Percent Passing | QA | 94.375 | 02/07/19 | 411 1 1/2|Percent Passing | 165 | 94.375 | |
| 411 | tbl AsphaltMixBase | 1|Percent Passing | QA | 92.5 | 02/07/19 | 411 1|Percent Passing | 166 | 92.5 | |
| 411 | tbl AsphaltMixBase | 2|Percent Passing | QA | 100 | 02/07/19 | 411 2|Percent Passing | 167 | 100 | |
| 412 | tbl AsphaltMixBase | #200|Percent Passing | OV | 11.76 | 02/07/19 | 412 #200|Percent Passing | 168 | 11.76 | |
| 412 | tbl AsphaltMixBase | #8|Percent Passing | OV | 44.11 | 02/07/19 | 412 #8|Percent Passing | 169 | 44.11 | |
| 412 | tbl AsphaltMixBase | 1 1/2|Percent Passing | OV | 94.70 | 02/07/19 | 412 1 1/2|Percent Passing | 170 | 94.70 | |
| 412 | tbl AsphaltMixBase | 1|Percent Passing | OV | 82.35 | 02/07/19 | 412 1|Percent Passing | 171 | 82.35 | |
| 412 | tbl AsphaltMixBase | 2|Percent Passing | OV | 100 | 02/07/19 | 412 2|Percent Passing | 172 | 100 |
v-piga-msft
Resident Rockstar
Resident RockstarHi jecochran ,
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 Regards,
Cherry