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/
If you look at the histogram, you see that time spent for session 4 and 5 is actually 23 and 15 respectively and not 6. The x-axis should be based on total time spent in a session. I can't seem to find a way to do it. Is there a code in DAX that can help me do this??
What's for the y-axis (and/or legend)?
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.