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 ...
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.