Histogram visual

[javedbh]

I downloaded histogram custom visual and sample from this url:

https://app.powerbi.com/visuals/

It seems that the visual removes the duplicates from the data i.e. gets distinct values and then creates bins and count items against each bin. This is clearly visible with the “Students exam result” page in the sample. I also tried this visual with my own data and noticed the same behavior. I think duplicates values should not be removed.

I have mailed the author about the problem and waiting for the reply. If it is fixed then it would be great.

*** or ***

Is there anybody that can help me achieve the same chart with with the existing/custom visual, any script or sample etc. ??

[ankitpatira · Accepted solution]

@javedbh have you tried Count instead of Count (Distinct0 ?

[javedbh]

@ankitpatira Previously I overlooked the "Frequency" thing because I didn't need it. I added required column under "Values" and it do not provide any option to use a function. However when I added the same column under "Frequency" and used "Count" (Not "Count Distinct") and it worked.

Thanks for pointing out.