Forum Discussion
Histogram custom bins
Hi, Kumar11109
There will be a menu when you click “1”, choose “New Group”, then you can see scene “6”. Let Group type be “Bin”, then choose Bin size as 2. As you can see the data in “5”, all the data group by 2 or whatever you want (>2, 2-4, 4-6 , 6-8).
Ps: 1. The axis and the value are the same column “Total Time Spent”.2. Reference: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-grouping-and-binning/
I have done the same thing that you have done. The y-axis is giving is the sum of minutes.
Hi Kumar11109,
Maybe this is what you want. If not, could you please create a sample visual with excel.
I used another method, in which I created another table and then used it to create the histogram.
Thanks BTW.
You are welcome. I am so glad you got it done.