Forum Discussion

lvanam's avatar
lvanam
Frequent Visitor
9 years ago

Histogram custom bins

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!

3 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    lvanam

     

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

     

    • lvanam's avatar
      lvanam
      Frequent Visitor
      9 years ago

      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's avatar
        Eric_Zhang
        Microsoft Employee
        9 years ago

        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.