Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
****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?