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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
h11
Helper III
Helper III

Line Graph for projects

Hello All,

 

My team has requested a line chart comparing "Project Completed per Month" vs "Projects Created per Month." I have data for approximately 250 projects and have attached a sample with 10 projects for reference. Could you please provide the formula to create a line graph where the X-axis represents months, and the Y-axis has two lines: one for the count of "Projects Completed per month" and the other for the count of "Projects Created per month"?

 

I request to attach the Power BI file if possible that you worked on using my data as a reference. Thank you in advance.

 

Project NameCreated DateCompleted Date
A10/18/202412/2/2024
B10/3/202410/30/2024
C10/3/202411/25/2024
D8/20/202412/31/2024
E1/3/2025 
F11/4/20241/17/2025
G9/13/202412/23/2024
H1/15/2025 
I10/25/20241/11/2025
J1/22/2025 
J10/12/2024 
1 ACCEPTED SOLUTION

hello @h11 

 

i might be misunderstood but do you have 25 more columns of date similar to 'Completed Date' and 'Created Date'?

 

also how do you get your data? if it is imported, you should have access to Power Query of your data? unless you get the data by Direct Query.

 

otherwise, please check this pbix if this suite to your requirement.

this is made without unpivot however the date table connected to 'Created Date' since looks like it will have value unlike 'Completed Date' which has blank value.

 

Thank you.

View solution in original post

3 REPLIES 3
Irwan
Super User
Super User

hello @h11 

 

please check if this accomodate your need.

Irwan_0-1737590961614.png

1. unpivot your table

Irwan_1-1737591002600.png

 

2. create two measures for completed and created

Completed = 
CALCULATE(
    COUNT('Table'[Attribute]),
    'Table'[Attribute]="Completed Date"
)
Created = 
CALCULATE(
    COUNT('Table'[Attribute]),
    'Table'[Attribute]="Created Date"
)

 

Hope this will help.

Thank you.

@Irwan Hi Irwan,

 

Thank you so much for trying to help me. Unfortunately, I cannot use this approach as I have more than 25 columns in my table and I can't unpivot my table by using the attribute and value in the table. Please help me with an alternate approach.

hello @h11 

 

i might be misunderstood but do you have 25 more columns of date similar to 'Completed Date' and 'Created Date'?

 

also how do you get your data? if it is imported, you should have access to Power Query of your data? unless you get the data by Direct Query.

 

otherwise, please check this pbix if this suite to your requirement.

this is made without unpivot however the date table connected to 'Created Date' since looks like it will have value unlike 'Completed Date' which has blank value.

 

Thank you.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.