Forum Discussion
Line Chart with overlapping dates
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?
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!
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.
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,
KellyDid I answer your question? Mark my post as a solution!
