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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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