Forum Discussion
Maintaining Week Over Week Historical Data
Hi there. Relatively new-ish to PBI & looking for assistance on how to automate week over week reporting inPowerBI. We currently have teams recording work units in various Jira ticket fields. Th...
Hi, MJT03
you can leverage Power BI's built-in data refresh capability and Jira's rest API.
- Connect Power BI to Jira using the Jira connector.
- Design your report in Power BI with the required visuals and columns.
- Set up a scheduled data refresh in Power BI to occur every Wednesday.
- Use Power Query Editor to transform and append Jira data, including calculating weekly unit counts.
- Build visualizations, such as a column chart comparing current and prior week unit counts.
- Publish the report and share it with stakeholders.
This is so helpful and straighforward, thank you! Can you elaborate on Step 4 and provide insight on how to begin that work? That seems to be the missing link for me. Thank you again!
Happy to help. Kudos will be more appreciated.
Sure. Elaborating the steps. though it will be a long process trying to give you an idea.
- In Power BI Desktop, open the Power Query Editor.
- Select the query that retrieves the data from Jira.
- Apply necessary transformations (e.g., remove columns, change data types, filter rows).
- Ensure you have a date column for work unit records.
- Create a new column for the week number using the Date.WeekOfYear function.
- Group the data by week number and calculate the sum of work units.
- Append the transformed data from each week.
- Close and apply the changes to load the data into your report.
NOTE:
Check the tutorial for PQ. https://learn.microsoft.com/en-us/power-query/power-query-ui
also you can look for youtube for basic tutorial for Power Query in Power BI.