November 12, 2021
My 12-month trend chart from Nov 2020 to Oct 2021 displays trend from Jan 2020 to Dec 2021 (24 months) when "Show items with no data" and For empty cells show "0" are enabled. Please see the attached sample chart. How can I display only the trend from Nov 2020 to Oct 2021?
Thank you in advance!
July 16, 2010
Welcome to our forum!
It's not clear why you need Show Items with No Data turned on. It seems pointless to display November and December 2021 in your chart when there is no data for those periods yet.
If you want to force these periods, then you'll need to add rows to your source data for those dates with zeros for each product. When you get actual data for those periods you can remove the zero value rows.