Forum Discussion
Customer Revenue bins
Hi all, I have a table that looks like the below and I am trying to create a histogram in which I categorize customers into 3 bins: < $10, $10-$20, and >$20. How would I create a measure that can bins customers like this?
Customer 1 has $7 total revnue, so it would be in the <$10 bin. Customer 3 has $30 total revenue, so it would be in the > $20 bin.
| Customer ID | Revenue |
| 1 | 2 |
| 1 | 5 |
| 2 | 10 |
| 2 | 4 |
| 3 | 10 |
| 3 | 20 |
4 Replies
- Ashish_Mathur
Super User
- jdbuchanan71
Anonymous
Take a look at this article that describes how to do what you are looking for.
- amitchandak
Anonymous ,
refer
Histogram
https://www.youtube.com/watch?v=9kp2Nu_LuXg
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380776?mktcmpid=Pickitli&tab=Overview
https://powerbi.tips/2016/04/power-bi-histogram-with-bins/SEGMENTATION
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization amitchandak jdbuchanan71 how do I write a measure that sums revenue by customer id though?
