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 ...
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!
Ah, you can create a calculated column like:
Month-Day = FORMAT('Table'[Date],"MM-DD")And use that as the Axis 🙂
ok tried that but still getting the day by day and a very long scroll bar.
Yes that makes it day by day because we created a column with Month-Day.
What would you expect to see? Per month?My reply with "December Cotton Futures" chart that is the expected outcome. that was done in excel.