Forum Discussion

Heena_9980400's avatar
Heena_9980400
Helper IV
1 year ago
Solved

Histogram in Power Bi

Hello everyone,   I’m trying to create a histogram in Power BI similar to the image below, where I have Upper Specification Limit (USL) and Lower Specification Limit (LSL) values that need to be sh...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from parry2k , please allow me to provide another insight:

    Hi, Heena_9980400 

    Thank you for your swift response.

     

    1.Based on the data you provided, I am currently unable to determine if it follows a normal distribution.Therefore, I created the following dataset to help you understand how to set it up:

    The median of this dataset is 19, and the variance is 361.

    2.According to your requirements, I used a column and line chart for visualisation, as shown in the image below:

    3.I placed the parameter points on the x-axis.

    4.The specific values were placed on the y-axis and the line y-axis. Of course, this can be replaced with the count of occurrences for the reference point.

    5.The vertical reference lines were set in the positions shown in the image below:

    6.Here's my final result, which I hope meets your requirements.

    My setup is just an example, so the specific settings may still need adjustments based on your parameters. I hope this helps.

     

    Please find the attached pbix relevant to the case.

     
    Of course, if you have any new ideas, you are welcome to contact us.
     

    Best Regards,

    Leroy Lu

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