Line Chart with overlapping dates

[bwilli33]

So I have yet to find anything that can help but i'd love to be able to make a line chart that compares contract years of a specific contract.  However the dates are unusual.  The contracts run from Dec 1st to Dec 14th of the next year.    so there is a bit of overlap

I am not sure how to insert images here this is my first time, but i can add some if needed

but the data is very simple..  

Date	Value	ContractYear
12/1/2009	444.5	2010
12/2/2009	438	2010
12/3/2009	433.75	2010
12/4/2009	424.5	2010
12/7/2009	419.75	2010
12/8/2009	420.75	2010
12/9/2009	420	2010

thoughts?

[Greg_Deckler]

@bwilli33 - I'm unclear on what you are looking for here. If it is date interval related, maybe Open Tickets? https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364. Like trying to see how many contracts are open at a time?

If it is a problem with time intelligence because of the weird contract period, You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[amitchandak]

@bwilli33 , not very clear. Use year as legend

[bwilli33]

yes i tried but i can't seem to get the dates at the bottom to just be days. but then the chart turns into a long daily chart with a horizontal bar ( i can get a pic if needed) otherwise this is what i get below.

Thank you for the help everyone!

[Anonymous]

Ah, you can create a calculated column like: 

Month-Day = FORMAT('Table'[Date],"MM-DD")

And use that as the Axis 🙂  

[bwilli33]

ok tried that but still getting the day by day and a very long scroll bar.

[Anonymous]

Yes that makes it day by day because we created a column with Month-Day. 
What would you expect to see? Per month?

[bwilli33]

My reply with "December Cotton Futures" chart that is the expected outcome. that was done in excel.

[v-kelly-msft]

Hi  @bwilli33 ,

Could you pls upload your .pbix file to onedrive business and share the link with us?Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[bwilli33]

Here is a link to download the file.  Thank you so much for the help

https://liveutk-my.sharepoint.com/:u:/g/personal/bwilli33_utk_edu/EfD2eVShqiNLrj7Sfv4ou4wBnIzMVSCez4...

[Anonymous]

Hi @bwilli33 

I used this data set as in your example i found no overlap:

12/1/2009	444.5	2010
12/2/2009	438	2010
12/3/2009	433.75	2010
12/4/2009	424.5	2010
12/7/2009	419.75	2010
12/8/2009	420.75	2010
12/9/2009	420	2010
12/7/2009	419.75	2011
12/8/2009	420.75	2011
12/9/2009	420	2011
12/10/2009	418	2011

I made the 3 overlaps bold. also assuming they have the exact same value. i created this linechart:

- There is an issue when uploading pictures.. Here is a link:
http://prntscr.com/txrfm0

I put Date in Axis, ContractYear in legend and value in values. 
Is this what you mean?

[bwilli33]

no i need the lines to lay on top of eachother

so the date range at the bottom should be Dec 1st to Dec 14th 

[v-kelly-msft]

Hi @bwilli33 ,

Is below what you need?

If so,put date to the X axis,and make it as date hierarchy,remove year and quarter,just keep month and day.

For the related .pbix file,pls see attached.

Best Regards,

Kelly

If I have solved your issue,pls mark the reply as answered!

[bwilli33]

Thank you, its very close.  the Y Axis should not be the sum but each point should be the non summarized values so it should range from like 300 to 800 i think.

[v-kelly-msft]

Hi @bwilli33 ，

It's just a workaround for you,if you wanna show the actual value,it would be shown as below:

As for the same point in time,not all the contract year have values,so if you wanna the 3 lines to start from the same point,the best way is to remove year and quarter,but it will make the values aggregated on the same month-day.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!