Forum Discussion

lvanam's avatar
lvanam
Frequent Visitor
9 years ago
Solved

Histogram - User defined bin size

Is there any way to define the user defined bin sizes in Histogram? 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: <10...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi lvanam,

     

    Based on my research, we can only specify Bins with specific positive integrate values to divide with equal range. It’s not supported to custom different ranges for each column in Histogram visual currently. I would suggest you send feedback to Power BI Custom Visuals Support alias: [email protected].

     

    Meanwhile, you can work around the issue use “Stacked column chart”,  below is the sample:

     

    Data table: Name, Amount(0~5000)
     

     

    Add a measure to calculate the range of amount.

    Range = var temp= SUM(Sheet1[Amount]) return 
if(temp<=100,"less than 100",if(AND(temp>100,temp<=300),"more than 100 and less than 300",if(AND(temp>300,temp<=500),"more than 300 and less than 500","more than 500")))

     

    add a calculate column to store the “range” and create a “Stacked column chart” visual to show the result.


     

    Regards,
    Xiaoxin Sheng

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi lvanam,

 

Based on my research, we can only specify Bins with specific positive integrate values to divide with equal range. It’s not supported to custom different ranges for each column in Histogram visual currently. I would suggest you send feedback to Power BI Custom Visuals Support alias: [email protected].

 

Meanwhile, you can work around the issue use “Stacked column chart”,  below is the sample:

 

Data table: Name, Amount(0~5000)
 

 

Add a measure to calculate the range of amount.

Range = var temp= SUM(Sheet1[Amount]) return 
if(temp<=100,"less than 100",if(AND(temp>100,temp<=300),"more than 100 and less than 300",if(AND(temp>300,temp<=500),"more than 300 and less than 500","more than 500")))

 

add a calculate column to store the “range” and create a “Stacked column chart” visual to show the result.


 

Regards,
Xiaoxin Sheng

 

jajohnson's avatar
jajohnson
Frequent Visitor
4 years ago

I am trying to implement this solution but the Range is not adding to visuals except in the tool tip field. Power BI is not allowing me to add it to the Axis field of the visual.