Report to show number of issues by Status by Week

[Aman-K]

Hi All,

I have 2 tables in Power BI, one named AllJiraData which takes data from Jira and the other one is Date table. I want to design a report which looks like below:

There is a status field in AllJiraData table which contains status for the issues e.g "In Progress","To Do" etc... "IssueDateCreated" field stores the date when issue was created and "ResolutionDate" field stores the date when the issue was resolved . Please see below sample data in both the tables .

Date table has below data:

Date	Month Year	Month Year Order	Year
01/09/2021 00:00	Sep-2021	202109	2021
02/09/2021 00:00	Sep-2021	202109	2021
03/09/2021 00:00	Sep-2021	202109	2021
04/09/2021 00:00	Sep-2021	202109	2021
05/09/2021 00:00	Sep-2021	202109	2021
06/09/2021 00:00	Sep-2021	202109	2021
07/09/2021 00:00	Sep-2021	202109	2021
08/09/2021 00:00	Sep-2021	202109	2021
09/09/2021 00:00	Sep-2021	202109	2021
10/09/2021 00:00	Sep-2021	202109	2021
11/09/2021 00:00	Sep-2021	202109	2021

AllJiraTable has below data:

WatchCount

IsWatching

UpdateDate

Channel

PriorityName

Priority.Id

DueDate

Status

Status.Id

StatusCategoryKey

StatusCategoryColorName

StatusCategoryName

issues.fields.aggregatetimeestimate

CreatorName

IsCreatorActive

IssueTimeSpent

issues.fields.customfield_10311.value

System Name

ProjectKey

ProjectName

issues.fields.project.projectTypeKey

issues.fields.customfield_10006

RAG

AssigneeName

ResolutionDesc

ResolutionName

TicketType

ProjectFundingOrNo

Impact(L/M/H)

ResolutionDate

ResolutionTime

IssueDateCreated

IssueTimeCreated

1

FALSE

2023-03-15T16:38:53.000+0000

UXP Channel

Medium

3

In Progress

4

indeterminate

yellow

In Progress

Sims, Aaron

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

GREEN

Sims, Aaron

########

11:32:02

1

FALSE

2023-02-15T16:05:24.000+0000

UXP Channel

High

2

In Progress

4

indeterminate

yellow

In Progress

0

Hammond, David

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Sims, Aaron

Support

Moderate

########

10:52:21

1

FALSE

2023-01-26T11:22:11.000+0000

UXP Channel

Medium

3

To Do

2

new

blue-gray

To Do

Baines, Adrian

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Hammond, David

Requirement

Project Funding

Moderate

28-Oct-22

12:21:46

Can anyone please help me in designing this report. Thanks a lot for your help in advance .

[Aman-K]

Sorry I can't share PBIX file due to restrictions at work . I have shared the sample data in the above post . Can anyone please help with this query?

Thanks

[bhelou]

Hello , can you share sample of the PBIX file , 
the first thing to do is to clean the data that is coming from Jira . 
for any inquiry contact me : bassem.7elou@gmail.com