Minimum number of data points to Plot box and whisker

[Anonymous]

I am trying to plot a box and whisker plot by month/year with the MAQSoftware version.

My data source only reports the five main quartiles for each month (Min, LwQ, Median, UpQ, MAX) instead of the raw data.

I unpivot the data in PowerQuery like the following screenshot:

Unpivoted data

And then I try to plot the box and whisker like the following:

Box and whisker

But PowerBI is summing the 5 data points instead of plotting them in the desired format.

Is it possible to "unsummarize" the data and plot a box and whisker plot for each month with just data about the five main intervals?

[ribisht17 · Accepted solution]

@Anonymous 

Solved: Avoid aggregation for scatter and box & whisker ch... - Microsoft Power BI Community

Regards,

Ritesh