Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
arne_christmann
Regular Visitor

Burnup Chart for open issues

Hi guys,

 

I need to create a burnup chart (line-chart) for open issues grouped by project and issue-type. The x-axis represents time (e.g. date) while the y-axis represents the amount of open issues at a date.

 

My table 'issues' looks like that:

 

ISSUE_IDPROJECT_IDISSUE_TYPECREATED_ONCLOSED_ON
whole numberwhole numbertextdatedate

 

I assume, that I have to create a 'time-table' with CALENDAR or CALENDARAUTO and join / summarize / group it somehow with the 'issue' table.

 

It would be great if you would give me some advice on how I can aggregate those information into a new table in order to display them in a line chart.

 

Thanks in advance,

Arne

1 ACCEPTED SOLUTION

Okay, I think I figured it out by myself.

 

I created a new table:

 

open_issues_timeline =
VAR _calendar =
    CALENDAR("01/01/2018", MAX(issues[created_on]))
RETURN
    CROSSJOIN(
                DISTINCT(
                        SELECTCOLUMNS(issues, "created.on", issues[created_on])
                ),
                DISTINCT(
                        SELECTCOLUMNS(issues, "tracker.name", fact_project_issues[tracker.name], "project_id", issues[project.id])
                )
    )

Then I added a new column:

 

open_issues =
COUNTX(
        FILTER(
                FILTER(
                        issues,
                        issues[tracker.name] = open_issues_timeline[tracker.name] &&
                        issues[project.id] = open_issues_timeline[project_id]
                ),
                (issues[created_on] <= open_issues_timeline[created.on]) &&

                (issues[closed_on] > open_issues_timeline[created.on] || ISBLANK(issues[closed_on]) )
        ), issues[id]
)

Not a very clean solution; but it works.

 

Thanks all for reading and replying. 

View solution in original post

3 REPLIES 3
ribisht17
Super User
Super User

@arne_christmann 

 

This video will show you https://www.youtube.com/watch?v=2f7dYB1l84g

 

How to connect Date with the Sales table, quite similar to your scenario, please  check

 

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

 

 

 

Thank you very much for your reply, @ribisht17 .

 

I already created a 'Date-Table' using calendarauto.  In order to create the 'burnup chart' I assume my 'date' table should look something like that (example):

 

DATEISSUE_TYPEPROJECT_IDCOUNT_OF_OPEN_ISSUES_AT_GIVEN_DATE
01.01.2022TASK124
01.01.2022CHANGE REQUEST14
01.01.2022TASK211
................

 

What kind of DAX do I need to write to combine / join both tables with the given columns?

 

Cheers,

Arne  

 

Okay, I think I figured it out by myself.

 

I created a new table:

 

open_issues_timeline =
VAR _calendar =
    CALENDAR("01/01/2018", MAX(issues[created_on]))
RETURN
    CROSSJOIN(
                DISTINCT(
                        SELECTCOLUMNS(issues, "created.on", issues[created_on])
                ),
                DISTINCT(
                        SELECTCOLUMNS(issues, "tracker.name", fact_project_issues[tracker.name], "project_id", issues[project.id])
                )
    )

Then I added a new column:

 

open_issues =
COUNTX(
        FILTER(
                FILTER(
                        issues,
                        issues[tracker.name] = open_issues_timeline[tracker.name] &&
                        issues[project.id] = open_issues_timeline[project_id]
                ),
                (issues[created_on] <= open_issues_timeline[created.on]) &&

                (issues[closed_on] > open_issues_timeline[created.on] || ISBLANK(issues[closed_on]) )
        ), issues[id]
)

Not a very clean solution; but it works.

 

Thanks all for reading and replying. 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.