Histogram in Power Bi

[Heena_9980400]

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 shown as reference lines on the chart. I also want to display the frequency distribution of my data (like the blue bars in the image) and overlay the LSL and USL lines as vertical dashed lines.

Here’s my data setup:

• I have a column of measured values (numeric data) for the histogram.
• I also have columns for LSL and USL values.

So far, I’ve tried adding the measured values to both the X-Axis and Y-Axis in Power BI, but no data is showing in the chart. I created bins manually, but the chart still isn’t displaying correctly.

Could someone guide me through the steps to:

1. Properly set up the X-Axis and Y-Axis to create a histogram.
2. Add vertical reference lines for LSL and USL.
3. (Optional) Add a smoothing curve over the histogram, if possible.

Any help or insights would be greatly appreciated!

Thank you!

[parry2k]

@Anonymous why would answer while we are waiting on a reply from OP? I don't understand the reasoning of your reply.

[Anonymous]

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

Here are the relevant links about building a histogram, I hope it will be helpful to you:
How to Make a Histogram in Power BI - Zebra BI

I would be grateful if you could provide me with the pbix file or sample data.This will give us a better idea of what you want the histogram to look like.

When uploading a file, please be careful to delete sensitive information.

Take care to remove sensitive data.

For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

If you have any other questions please feel free to contact me.

Best Regards,

Leroy Lu

[Heena_9980400]

Hi @Anonymous  , 

Thanks for your response.

Please find the histogram and sample data snapshot .

Thanks ,

HK

[Anonymous · Accepted solution]

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.

[parry2k]

@Heena_9980400 can you share the image along with sample data?

[Heena_9980400]

Hi @parry2k , 

Thanks for your response.

Please find the histogram and sample data snapshot .

Thanks ,

HK