Forum Discussion
Unknown value in histogram
Hello Microsoft Power BI Community.
I am developing a histogram in my project, with data starting at 6000 frequency. However, my histogram returns an unknown number 1. Below, print the data. can you help me? Remembering that the X and Y axes are automatic, and I am working with 20 bins. In other bins, the number 1 is also displayed.
Thank you!
Anonymous
Frequency in “Histogram” usually count the frequency of “Values” in the visual. For example, frequency of “1-5” is 4 which counts the Sales, not the sum of “Whatever”. Reference here: https://en.wikipedia.org/wiki/Histogram
In this case, you may use a Clustered Column Chart with bins to categorize the “Value”. (Click New Group to create bins.)
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous
I couldn't reproduce that issue like your screen, can you maybe share sample pbix. However, sometimes custom visuals that from Appsource experience unknown issues. Try reopen the pbix see if it occurs everytime.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I shared the pbix file in my personal repository, follow the link below:
https://drive.google.com/file/d/1m3ZHjLG8eApvQRCI-Yiedox9ZYmuMEUF/view?usp=sharing
As shown below, when the values of 5.22k to 6.96k are selected, 140.48 is returned and its total sum is 139.32. This inconsistency is also realized by the graph in other values...
I would like you to help me to locate this error, or in something that may be correct to my data.
Thanks for the support!
Anonymous
Frequency in “Histogram” usually count the frequency of “Values” in the visual. For example, frequency of “1-5” is 4 which counts the Sales, not the sum of “Whatever”. Reference here: https://en.wikipedia.org/wiki/Histogram
In this case, you may use a Clustered Column Chart with bins to categorize the “Value”. (Click New Group to create bins.)
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.