Forum Discussion

k943's avatar
k943
Helper I
2 years ago

Create a boxplot by giving Power BI the needed parameters

Hi,

 

I know there are visuals that can calculate internally boxplot parameters like mean, median, 1st and 3rd quartertile...etc and create the visuals. But Is there a way that I just feed in these parameters to Power BI and it will just create the boxplot?

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi k943 ,

    Thank you for your question. Yes, you can create a boxplot in Power BI by feeding in custom parameters like mean, median, 1st and 3rd quartile. Here’s a general approach to creating a boxplot with provided parameters in Power BI:

    1.Download a box-and-whisker plot custom visual from the Power BI visuals gallery.

    2.Import the custom visual into your Power BI report.

    3.Ensure your data model has the calculated statistics ready to be used.

    4.Add the custom visual to your report ,and the calculated statistics as values for the respective fields in the visual’s configuration.

    You can achieve the results you want by following these steps. For more detailed instructions, you can refer to the Power BI blog post on box-and-whisker plots:

    Visual Awesomeness Unlocked – Box-and-Whisker Plots | Microsoft Power BI Blog | Microsoft Power BI

     

    Best Regards,

    Yifan Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

    • k943's avatar
      k943
      Helper I

      What if I do not have the actual data points but only the parameters i.e. minimum, maximum, mean, median, 1st quartile, etc.

    • dppl2020168's avatar
      dppl2020168
      New Member

      You did not even attempt to read the original post did you?