Forum Discussion
Helper IIIBox and whisker set up
Hi all,
I have data that has a category, sub category, and results(between 0 and 1). A subcategory in one is not in the another, so Subcategory 1 will ONLY be in Category 1.
| Category | Sub Category | Result |
| 1 | 1 | 0.29 |
| 1 | 1 | 0.56 |
| 1 | 2 | 0.38 |
| 1 | 2 | 0.44 |
| 1 | 2 | 0.63 |
| 1 | 3 | 0.21 |
| 2 | 4 | 0.15 |
| ... | ... | ... |
I am trying to make a box and whisker plot to show each sub categories on the x-axis, with the category as a legend, and results on the y. I've tried using the MAQ box and whisker. However, it takes in an average of Result for values rather than individual values. So when you try to group by the category, it'll weigh the 3 subcategories equally which results in an incorrect overall average and other information... What is the best way to set this up?
I've tried Jan Pieters and the MAQ one. For the Jane Pieters, I have Category in Category. subcategory in sampling, and average of result in values. In the MAQ, I tried subcategory, then category in the same designation for Axis I, average of result in Value, and category in legend
5 Replies
Hi goalie_ ,
See if this helps
https://community.powerbi.com/t5/Desktop/Box-and-Whisker-Plot-in-Power-BI/m-p/437375
Regards,Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!
v-yingjlCommunity Support
Hi goalie_ ,
"However, it takes in an average of Result for values rather than individual values."
I think you are referring to the “don’t summarize" function on the values field in this chart.
The Box and Whisker chart needs data is a specific way.
- Category - This field contains the categories. For each (unique) category a different chart is drawn.
- Sampling - All these fields are being used to 'sample' the dataset or 'creates rows'.
- Values - The values field contains a numeric value to calculate the statistic values needed for the charts.
This is also the reason that the option 'Don't summarize' is not available for this chart: it is how the data is bound to the visual.
Since this is a custom visual, power bi desktop cannot change the properties of this chart itself, you can add some coments under the visual page in app source, or try to contact the visual owner @ jppp.
Refer this issue: Box and Whisker Plot
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
goalie_Hi,
Any ideas how I can manipulate the data table to get what I need?
- MAQSupport
Solution Supplier
Hello goalie_ ,
Data is being split at the granular level using the column in Axis data field. Hence the "Do not summarize" option has not been provided for the values.
For example, To show the distribution of Result by SubCategory in Box and Whisker by MAQ Software, you can have the following data field configuration:
Let us know if it meet your requirements and revert back in case of any issues.
For any further queries or enhancement requests, please contact us at Support
Thanks
