Creating Bined Histogram from Subtotals

[JuanD]

I want to create a histogram of sales information.

I currently have a single table givin me

- OrderID, type of product, quantity, price

As such if you buy 3 different types of products, you would get 3 different lines in the DB.

I'm trying to create a histogram of size of order. But if I used the standarized Group / Bins on the quantity metric I get the histogram at a product level (quantity of each product).

How can I make subtotal ranges for the same OrderID so I can later use them as bins in the histogram.

Order sizes 1-10, 10-20, 20-30...etc up to 1500.

Thanks everyone.

[lbendlin]

Power BI does not support dynamic bucketing. You need to bring your own precompiled list of all possible buckets. 

Your buckets won't work as they are overlapping.