Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Box & Whisker Plot in Power BI

Doesn't allow me to attach spreasheet file with a Box & Whisker plot. Can anyone help in replicating the view in Power BI

 

I get a nice view with Total, Open & Closed bars based on the data below when i select the Box & Whisker plot in excel for the data below -

 

 TotalClosedAdded
Nov089695647587089
Nov896956475870899242034
Dec090681128,638,000
Dec90681128,638,0009,522,819
Jan08,855,4746,320,581
Jan8,855,4746,320,5819,074,353
Feb07,573,3663,345,939
Feb7,573,3663,345,9395,822,961

The Total provides the start and end of the first bar. Closed column start with Total - 2 row and similarly, Added column starts with Closed - 2nd column.