Boxplot chart (percentiles)

[Anonymous]

Hi all,

I'm starting to use Power Bi and I need some help with an analysis:

- I have a database of users making queries in a system. The database shows the time it takes to process the query (Elapsed Time) so I need to build a monthly percentile, a boxplot, excluding the 10% queries with the HIGHEST and LOWEST of Elapsed Time, in order to get an Average which is not affected by this bias. 

- It would be great if is a boxplot like in the image of the link I paste below. 

- I also paste an example of the database. 

Database: 

Date	User	Workbook (query)	Elapsed Time
10/1/2019	UKN1	Demand Review	0.20
10/2/2019	UKN2	Demand Review	0.23
10/3/2019	UKN3	Demand Review	0.00
10/4/2019	UKN4	Demand Review	0.32
10/15/2019	UKN5	Demand Review	0.27
10/16/2019	UKN6	Demand Review	0.22
10/27/2019	UKN7	Demand Review	50.34
10/28/2019	UKN8	Demand Review	30.40
10/29/2019	UKN9	Demand Review	0.50
10/30/2019	UKN10	Demand Review	0.00

Boxplot: 

https://towardsdatascience.com/understanding-boxplots-5e2df7bcbd51

Thanks in advance,

kr, Roger 

[Anonymous]

Hi @Anonymous ,

I check power bi visuals but haven't found any visual can show boxplot, I'd like to suggest you refer to your link to create an r visual with r script to manually draw boxplot graph.

Create Power BI visuals using R 

Regards,

Xiaoxin Sheng