Forum Discussion
Kumar11109
Helper IV
9 years agoHistogram custom bins
Hi everyone, I am new to power bi and I am stuck. I need to create time spent bins for a histogram. How should I create bins like >2, 2-4, 4-6 , 6-8... Etc. Please help its urgent.... Y...
- 9 years ago
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/
Kumar11109
Helper IV
9 years agoI used another method, in which I created another table and then used it to create the histogram.
Thanks BTW.
v-jiascu-msft
Microsoft Employee
9 years agoYou are welcome. I am so glad you got it done.