Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Here are troubleshooting tips I have tried:
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.
Thank you!
Hi @jecochran ,
If it is convenient, please always show your sample data in text-tabular format in addition to (or instead of) 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
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 |
Hi @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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |