Forum Discussion
Line Graph for projects
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.
hello h11
please check if this accomodate your need.
1. unpivot your table
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.