Box and Whisker Plot in Power BI

[Art]

I have a data set below and I am trying to plot the Box and whisker plot for the three serial No and trying to find if there any RPM that are outliers. I tried using MAQ and Jan Pieters but could not do it. Can anyone tell me the steps to make a box and whisker plot with this data. Adding RPM to values of the boxplots are not allowing me to select DO NOT SUMMARIZE.

Serial No	Date	RPM
12W33	6/7/2017	11
14J33	6/8/2017	23
55x44	6/9/2017	56
12W33	6/10/2017	33
14J33	6/11/2017	33
55x44	6/12/2017	33
12W33	6/13/2017	4
14J33	6/14/2017	55
55x44	6/15/2017	55
SEQUENCE	DATES BELOW	VALUES
CONTINUES	BELOW

[Thejeswar]

Hi @Art,

Can you tell me why do you want to set Data Category as "DO NOT SUMMARIZE" for RPM?

The Basic Functionality of Box and Whisker Plot is to consider all the values of the samples available for the Category. This Sampling is grouped based on the Item you specify in the "Sampling" option of the chart. In your case, when you have the category as "Serial No.", Sampling as "Date" and Value as RPM, it groups the data of RPM for Date binned by Serial No.

So ideally, some summarization has to be set for the column used in the value section.

You might be knowing, you cannot group a value without aggregating it.

For Ex.

Your Box and Whisker Chart Query is more like the one below

Works:

Select SerialNo, Date, SUM(RPM) from table1

group by SerialNo, Date

When you make the value as Do not summarize, it looks more like the one below

Does not Work this way:

Select SerialNo, Date, RPM from table1

group by SerialNo, Date

Regards,

Thejeswar

[Art]

@Thejeswar I want to coniser the RPM for each machine as a sample. For example 12W33 is a sample. And RPM are the values in that sample and I want to find the outliers in that sample. We cannot just add two intances of profit on the same day say 75% and 75% and say the total profit that day was 150%. In this case summarize won't work. Did you get it?

[Thejeswar · Accepted solution]

Hi @Art,

PFB image showing outliers in Box and Wisker chart

The Above Visual shows the outliers present in the data for each sample.

Actually the sample data which you provided was not giving any outliers and hence I added a 2 more records to the data for the each sample.

Also I used the Wisker Type as Custom and gave my own Low% (10) and High% (90) Values to get the outliers displayed. I am not sure if the outliers will be automatically displayed in the other wisker types as this data was not giving me any outliers in the other wisker types (even after adding few records)

I think with large amount of data for each sample you will be able to see the outliers in each sample.

Hope this is what you were in need of and let me know in case you want the data sample I used for this