Histogram custom bins

[lvanam]

Hello everyone,

I downloaded the Histogram visual from https://app.powerbi.com/visuals/ to my local and when I imported this visual on the power Bi desktop, I dont see an option for changing the bins. In fact I dont see Bins in the General options at all. I only see options for X-positiom, Y-position, Width and height unlike sample example. Please tell me where the disconnect is? Thank you!

[Eric_Zhang]

@lvanam

Based on my test, you will have to fill the values field then the "Bins" would be activated.

[lvanam]

Thank you! That worked. Is there any way to define the custom bin size?

For example I have a field called Product size that has data varying from 0 to 5000.I want to be able to divide the bins as:

<100, 100-300, 300-500 and 500+ for the histogram. If I define the custom bin size as 4, it automatically divide it into bin sizes with equal number of intervals. I want to be able to define the sizes as above. How do I do that?

[Eric_Zhang]

@lvanam

As far as I know, there's no way to custom BIN ranges, you can submit and vote up an idea on Power BI ideas. As a workaround, may be you can try to use some calculated column(column = if ( value<100 then "<100",if(value<200,"100-200",">200")) and apply the column to visual accordingly.