Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello Everyone,
I need your Help generating a chart showing the average & Cumalative trend over time for a dataset.
Production Explaination:
In the production process, we create 1 Module, and this module is made up of 16 Skids. Each skid is considered finished when a specific activity is marked as 100% complete,my goal is to analyze our production data to understand the average & Cumalative trend for the number of skids we produce each month.
Dataset Explaination
To illustrate this, I have provided a link to the dataset we are working with,2 tables are interconnected through column (EquipmentId),1st table(ActivtiyLevelProgress) is having the ActivityDescription & Progress while the other column is having the
CWP_or_Skid ,InstallationEnd & InstallationStart.
1st Table ActivityLevelProgress (highlight is the 2 Most important columns)
2nd Table Equipment ((highlight are the 3 Most important columns)
Link to Dataset
SampleDataset
What do i need to do
I need to create a couple of measures 1 Monthly Average,1 total till date (Aggregation),dynamic time X Axis
1- Dynamic time X-Axis based on InstallationEnd & InstallationStart which changes based on ActivityDescription.
2-Monthly Average Measure should count the Number of CWP_or_Skid that are finished based on ActivityDescription & Progress in every month while referring to a dynamic time X-Axis (InstallationEnd & InstallationStart)
3-1 total till date (Aggregation) while counts the total number of CWP_or_Skid that are finished based on ActivityDescription & Progress in every month in an upward trend while referring to a dynamic time X-Axis (InstallationEnd & InstallationStart)
Outcome chart would look like
Dotted is the average & straight line is the
Your insights and expertise will be invaluable in this endeavor.
@amitchandak @lbendlin @Ahmedx @parry2k @Ritaf1983
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
I have provided a sample dateset in excel format in the orginal post
access denied - please check
Thank you for your Response
I have checked the link and it should be working
Thank you for your clarification..i will do so
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
211 | |
86 | |
64 | |
59 | |
56 |