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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
****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?
Are you summing your Order IDs instead of counting them?
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