The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
****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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.