Forum Discussion
Line Chart for tracking Market Share
TomR726 if you don't have the date column at the source, Power BI will not able to generate it by itself. That's it. You need to bring the date column to your source to make it work.
Fair enough, I can look in to trying to add that in despite the manual issue. One last question, when I add that in and change it over time- Say I make a change august 22nd that takes market share from 73.3% to 61.1%, then another change August 28th going from 61.1% back to 73.3% because I found out that area does not apply. The last modified date in the source excel spreadsheet would be August 28th, so would I need multiple columns that shows every date change, or just the most recent? i feel like I may be getting in to the exact same problem with that if its kept in one column unless I am misunderstanding