Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! 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?
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.