I have calculated YoY% using Lookup function and am using those fields in the trends line chart.
There is no YoY% calculated for previous months lacking data, thereby view for the first few months is blank/missing and showcases the view like the one attached-
I would like to restrict the view with latest 12 months to be displayed but unfortunately its taking away my calculated YoY fields.
Any chance i can have YoY% fields intact and also have only latest 12 months displayed.
Right click on the labels that have no data and select "Hide" (not "Exclude")