Forum Discussion
Histogram - User defined bin size
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
I can't get u clearly :-(,
If my assumption , after the result u want to show the range in proper order like Asc or Desc ? if yes
i have to create one more column with order number based on Range Output
Hi Baskar
I created another column similar to Range (measure) and I gave the values such as 1,2,3,4. The idea is to sort the prior range column with Range1 column. RangeSort = var temp= SUM(Query2[Age]) return Switch(True(),AND(temp>=6,temp<6),"1",AND(temp>=6,temp<11),"2",AND(temp>=16,temp<31),"4",AND(temp>=31,temp<61),"5",AND(temp>=61,temp<121),"6",AND(temp>=121,temp<10000),"7")
I now get an error message "Circular dependency was detected between RangeSort1, Range1, Rangesort1 :(
Did any one got any solution for sorting the range as required? I am also facing the same problem as lvanam mentioned. My range is coming >14, 0-1, 2-7, 8-14 whereas I need it like >14, 8-14, 2-7, 0-1.