User Profile
jray
Advocate I
Joined 8 years ago
User Widgets
Contributions
Do Not Summarize option missing for Box & Whisker
The option to 'Do Not Summarize' values for the box & whisker plot visualisations is not appearing in Desktop version of PowerBI. This applies to both the custom visualisations from MAQ Software (recently promoted in the latest PowerBI Jan 2018 release) and the one by Jan Pieter Posthuma. While I can get the box & whisker plot to appear by selecting value summarisations of either Average, Median, Minimum, or Maximum, the calculations appear to be incorrect if I do this. I have compared against a manual analysis in Excel and the data summary listing the median value is definitely incorrect on the visualisation if I use any of the summarisations. I have also tried to export the data to see what was happening and noted that it is also missing many data points - there should be about 3,330 data points in one of the subsets I am trying to visualise, but it only seems to analyse between 300-1,000 data points which is also contributing to the incorrect calculations. My data is an Excel file import and the data column type is set to 'Decimal Number'. When I tried to research the problem, I found the following instructions in the Jan 2016 'announcement' about JPP's visualisation which say to 'Make sure to mark the aggregation as ‘Don’t summarize’ in the Value bucket for each series', but there is no such option appearing for me - see https://powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-box-and-whisker-plots/. I suspect this is why I am getting the wrong values showing in the chart summary. Does anyone know how to get the 'Do Not Summarize' option to appear for the box & whisker plot visualisations?17KViews9likes11Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.