Forum Discussion
Histogram in Power Bi
- Anonymous1 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.
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
Hi Anonymous ,
Thanks for your response.
Please find the histogram and sample data snapshot .
Thanks ,
HK
- Anonymous1 year agoNot applicable
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.