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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ah, you can create a calculated column like: 

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

And use that as the Axis 🙂  

bwilli33's avatar
bwilli33
Helper I
6 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

    • bwilli33's avatar
      bwilli33
      Helper I
      6 years ago

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

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        6 years ago

        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!