Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
****PLEASE HELP, POWER BI NOOB this side****
Hi,
I have the following sample table as my data input:
| Order ID | City | Customer | Order Date | Step 1 | Step 2 | Step 3 | Step 4 |
| 2 | New York | ABC | 25/12/2020 | 12/1/2021 | 18/1/2021 | 30/1/2021 | |
| 4 | San Francisco | ABC | 15/1/2021 | 27/1/2021 | 29/2/2021 | ||
| 10 | Los angeles | XYZ | 25/2/2021 | 19/3/2021 | 20/4/2021 | 22/4/2021 | 29/4/2021 |
| 17 | Dallas | XYZ | 27/3/2021 | 25/4/2021 | |||
| 35 | Dallas | XYZ | 19/4/2021 | 20/5/2021 | 21/6/2021 | 28/6/2021 |
There are 4 steps for each order, and I want to see on a graph the overall running total and each month/week progress for order date and each step. To this I want to add slicers for city and customer (both functioning together).
I tried creating a calculated column but when I use that for a graph, it sums up all values and gives me a huge number (In picture below). Plus I am not able to add slicers to this.
This figure for December should be 245.
Can someone please help?
No, I created a new table with the 1st column with all the dates for this year and then a calculated column which calculates no. of orders undergoing each step before each cell value(dates) in the 1st column. And it does calculate it correctly but when I use that on a chart, it automatically sums up the values. Plus, I cant add slicers to that.
This visual is named total orders but it is the no. of orders undergoing step 1 for each month. The actual no. is not 11k but 245
Are you summing your Order IDs instead of counting them?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 2 | |
| 2 | |
| 2 |