Forum Discussion
Solved
Stacked Area Chart - Convert to Monthly
Hi, I have some daily data which I have converted into a stacked area chart. The chart looks messy as there are too many data points so looking to convert to monthly data for the chart. However...
Oh, I missed to tell you to add the Month column as well. You can add it as a new column in your date table with a formula like this:
Month_Name = FORMAT(Table[Date], "MMMM")
Oh, I missed to tell you to add the Month column as well. You can add it as a new column in your date table with a formula like this:
Month_Name = FORMAT(Table[Date], "MMMM")