Forum Discussion

goalie_'s avatar
goalie_
Helper III
6 years ago

Box 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 Categ...
Need Help
Tutorial Requests
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

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 Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • goalie_'s avatar
    goalie_
    Helper III
    6 years ago

    Hi,

     

    Any ideas how I can manipulate the data table to get what I need?

    • MAQSupport's avatar
      MAQSupport
      Solution Supplier
      5 years ago

      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