Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm trying to make a production calendar with start and end date for each production order and product as well as single and summed quantities. Here is a sample data, similar to the one I want to use:
The visual effect which I'm looking for is something like this:
Thanks!
Solved! Go to Solution.
I've seen a few different approaches to this type of problem, this is one using some M custom columns in Query Editor in PowerBI to generate a 'X Daily Value by Date'. Detailes below by each screen shot:
Thank You,
FOrrest
1: Here's the first code for a Custom Column to divide the Total Production by the number of days between Start and Due. (Adding 1 to Inclusive the 2 dates.)
= [Total_Prod_Qty] / (Duration.Days(Duration.From([Run_Due_Date]-[Run_Start_Date]))+1)
2: Next we need to identify all the individual dates between the Start Date and Due Date. This M code will generate a Custom Column with these dates in LIST format. You can expand this list as shown below to get a ROW for each date between the Start and Due Dates. ** Adding your Daily Total in Stpe 1 FIRST automatilly spreads this value out during this steps. **
= { Number.From([Run_Start_Date])..Number.From([Run_Due_Date])}
3: Format the new Column as a DATE for Power BI to convert the date numbers to a more user friednly format. Now we can start building visuals based on this new Date Custom Column in Power BI
4: The Matrix in this screen shot is cloest to what you where looking to build. The Matrix set-up is shows in the screen shot. I haven't played with colors yet, but it's a start. I also created the stacked bar graph with nicely shows the upcoming drop off of production!
Proud to give back to the community!
Thank You!
I've seen a few different approaches to this type of problem, this is one using some M custom columns in Query Editor in PowerBI to generate a 'X Daily Value by Date'. Detailes below by each screen shot:
Thank You,
FOrrest
1: Here's the first code for a Custom Column to divide the Total Production by the number of days between Start and Due. (Adding 1 to Inclusive the 2 dates.)
= [Total_Prod_Qty] / (Duration.Days(Duration.From([Run_Due_Date]-[Run_Start_Date]))+1)
2: Next we need to identify all the individual dates between the Start Date and Due Date. This M code will generate a Custom Column with these dates in LIST format. You can expand this list as shown below to get a ROW for each date between the Start and Due Dates. ** Adding your Daily Total in Stpe 1 FIRST automatilly spreads this value out during this steps. **
= { Number.From([Run_Start_Date])..Number.From([Run_Due_Date])}
3: Format the new Column as a DATE for Power BI to convert the date numbers to a more user friednly format. Now we can start building visuals based on this new Date Custom Column in Power BI
4: The Matrix in this screen shot is cloest to what you where looking to build. The Matrix set-up is shows in the screen shot. I haven't played with colors yet, but it's a start. I also created the stacked bar graph with nicely shows the upcoming drop off of production!
Proud to give back to the community!
Thank You!
Thanks a lot. Works very good!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |