Forum Discussion
Fixed bins on dynamically selected data
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Create-a-bar-graph-with-measures-as-axis/td-p/455900
milpro011 are you able to provide some data? ie. copy and paste same into the window?
vanessafvg thanks!
A simplified dataset is along the following lines (sorry, I can't paste the actual data for privacy reasons).
Year | Salesperson | Product | Lot# | Qty
2019 Joe Cups A1 3
2019 Joe Cups A2 4
2019 Matt Cups A1 4
2019 Matt Cups A5 4
With filters :
Year: 2019
Product: Cups
And using a regular PowerBi table, data is reduced to:
Salesperson | Qty
Joe 7
Matt 8
James 3
Greg 2
Mitch 9
etc.
I'm looking to bucket and count how many sales reps have sold a certain amount of product
If we have 2 buckets: 1-6 and 7-13, we would have the answer
Bucket | # of Salespeople
1-6 2
7-13 3
Thanks!