Forum Discussion
Line Chart with overlapping dates
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?
14 Replies
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/txrfm0I put Date in Axis, ContractYear in legend and value in values.
Is this what you mean?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
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 , not very clear. Use year as legend
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!
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-TITHW/m-p/434008Otherwise, 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.
