cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gooranga1 Senior Member
Senior Member

box and whisker visualisation

I don't have much experience with box and whisker plots and I am struggling to make the results returned in it to the measures I have created on the same data. I have used MEDIAN and AVERAGE in the functions in the table and based the box and whisker on the same data. 

 

I am not sure what samplng and values are. It is calculating the average median seconds a door is open. Messing around the only way I can get a chart is by the screenshot below. The maximum is correct but the median and average aren't. I presume from the #samples refers to the number of rows being used? Which is lower than the table is using so that I presume is why it is different. 

 

Anyone give me a hint of where I am going wrong?

 

box and whisker set up.PNGproblem with box and whisker.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
gooranga1 Senior Member
Senior Member

Re: box and whisker visualisation

I ended up using the R visualisation and used ggplot2 library using geom_boxplot which after a bit of messing about does the job.

 

The R plotly library looks to have more featues and allows data labels. I could get it to work in R Studio but it didn't seem to work in power bi very well which was a shame.

 

R-ggplot.PNG

5 REPLIES 5
Community Support Team
Community Support Team

Re: box and whisker visualisation

Hi @gooranga1,

 

Values are the values to evaluate. Sampling is the way to group Values. You can see the numbers behind the visual by click the ellipsis in the upper right and select "see data". You will get the idea soon. I create a visualization that is similar with yours.

The values are grouped by color first, then are grouped by Quantity members.

box and whisker visualisation.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gooranga1 Senior Member
Senior Member

Re: box and whisker visualisation

Thanks @v-jiascu-msft 

 

I understamd it a bit better now. I actually didn't want any sampling so I used an index column which worked! ......but!

 

It made the chart really really slow. So slow it was unusable. I also was unable to change the data colours and because it was taking minutes for each update I had to give up.

 

Shame really but I think there was to much data for it in this case.

 

Thanks for your help.

Community Support Team
Community Support Team

Re: box and whisker visualisation

Hi @gooranga1,

 

Maybe you can try to summarize the data first, there could be less computing. In my example, I can try to create a new table like this.

Table 4 =
SUMMARIZE (
    'Sales',
    'Product'[Color],
    Sales[Quantity],
    "sumQuantity", SUM ( Sales[Quantity] )
)

box and whisker visualisation2.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gooranga1 Senior Member
Senior Member

Re: box and whisker visualisation

Thanks @v-jiascu-msft

 

I did have a think how I could summarise the data but not sure I can. We have thousands of doors that can get opended multiple times in a day. We would like to get acurate overview of the opening times of the doors. Not sure how I could summarise that data to get this as I think I need the raw data to get acurate figures. I will keep looking at it though and see If I can find a way to do this.

 

Cheers

gooranga1 Senior Member
Senior Member

Re: box and whisker visualisation

I ended up using the R visualisation and used ggplot2 library using geom_boxplot which after a bit of messing about does the job.

 

The R plotly library looks to have more featues and allows data labels. I could get it to work in R Studio but it didn't seem to work in power bi very well which was a shame.

 

R-ggplot.PNG