Forum Discussion
Kumar11109
Helper IV
Helper IVHistogram 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...
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/
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Kumar11109,
Maybe this is what you want. If not, could you please create a sample visual with excel.
Kumar11109Helper IV
Helper IVI used another method, in which I created another table and then used it to create the histogram.
Thanks BTW.
- v-jiascu-msft
You are welcome. I am so glad you got it done.