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.
Hi,
I have 76 data in my Excel but the box and whisker I created shows only 56 sampled. This affects the median results. Anyone can help?
Eng chuan
Solved! Go to Solution.
HI @zuozk123,
According to your snapshots, it seems like your category fields contain a few duplicate values. When you use on charts, visual only display distinct category field and will aggregate its records. (current you can't cancel this summarize on charts)
You can use your fields on table visual and right-click fields to choose 'do not summary' option to force display all records without aggregate.
Regards,
Xiaoxin Sheng
Hi @zuozk123,
It seems like your records have been summarizing by your category fields, you can consider adding an index column to your table and use it on visual to keep all records.
In addition, you can also try to write a measure to manually calculate with table row count instead of aggregate functions.
Regards,
Xiaoxin Sheng
Hi
i am hoping by adding pics will help you to explain to me again. i took a snapshot of my excel data (76 data points) and a pic of my box and whisher. it seems my histogram has the similar issue of ploting 56 data only too. Thank in advance for your advise.
HI @zuozk123,
According to your snapshots, it seems like your category fields contain a few duplicate values. When you use on charts, visual only display distinct category field and will aggregate its records. (current you can't cancel this summarize on charts)
You can use your fields on table visual and right-click fields to choose 'do not summary' option to force display all records without aggregate.
Regards,
Xiaoxin Sheng
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |