Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Box Plots in Power BI

Hi,

 

I'm trying to create a box plot for the client where in only the Min,Max and Median are required on the plot.

I have tried various box plots using custom visuals(one from Maq software and one from Brads Box plot), but there are no options to do that.

 

Also I dont get the "Don't Summarize" option when trying to create one. I'm always forced to choose an agregation which is against the purpose of showing a box plot.

 

 

 

Need Help

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    As far as I know, the results of a box visual contain many required value. Please refer to https://en.wikipedia.org/wiki/Box_plot. 

    Can you share a sample, please? Maybe we can find a workaround. Please mask the sensitive parts first.

     

    Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

    Best Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello,

       

      Here is some sample data.

      So there will be 6 box plots by "Config Type" and "Type" and "Profit" Distribution to be plotted on Box plot.

       

      Config TypeTypeProfit
      PremiumOnline12855
      AverageOnline14510
      BudgetOnline13639
      PremiumOffline10285
      AverageOffline14690
      BudgetOffline10733
      PremiumOnline10055
      AverageOnline13155
      BudgetOnline13755
      PremiumOffline14172
      AverageOffline11153
      BudgetOffline13509
      PremiumOnline14959
      AverageOnline14612
      BudgetOnline12159
      PremiumOffline13857
      AverageOffline10957
      BudgetOffline10508
      PremiumOnline11518
      AverageOnline10168
      BudgetOnline12375
      PremiumOffline14739
      AverageOffline12327
      BudgetOffline11299
      PremiumOnline14239
      AverageOnline12555
      BudgetOnline13187
      PremiumOffline13984
      AverageOffline11228
      BudgetOffline11364
      PremiumOnline12174
      AverageOnline10319
      BudgetOnline11763
      PremiumOffline13545
      AverageOffline13754
      BudgetOffline14921