Creating Bined Histogram from Subtotals
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.
Adjust matrix dates (in intervals) based on slicer selection
Hello, I have a Power BI report where I am using the Matrix Visual and have a date slicer. In the matrix, I have the Date value in the Column field. I need the dates to adjust with the dates selected in the slicer and also show in intervals of 7 days. I have tried binning the Date field into 7 days, but the last day shown in the Matrix is related to the latest Sunday, vs the last date selected in the slicer. I have also tried several dax formulas, but I can only get the last date shown in the matrix to correspond with the Maximum date in my data set. Any ideas on a formula that will allow me to show the Date field in the matrix in increments of 7 days and also display the last date that corresponds with the latest date selected in the slicer? (In my example below, the last date in the matrix should be 8/31 instead of 9/2). Here is the formula I am using to achieve this:
