Forum Discussion

bwilli33's avatar
bwilli33
Helper I
6 years ago

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 ...
Need Help
bwilli33's avatar
bwilli33
Helper I
6 years ago

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's avatar
v-kelly-msft
Community Support
6 years ago

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's avatar
    bwilli33
    Helper I
    6 years ago

    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's avatar
      v-kelly-msft
      Community Support
      6 years ago

      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!