Forum Discussion
Kumar11109
9 years agoHelper IV
Histogram 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
9 years agoHelper IV
I used another method, in which I created another table and then used it to create the histogram.
Thanks BTW.
v-jiascu-msft
9 years agoMicrosoft Employee
You are welcome. I am so glad you got it done.