Thanks for your response.
Here are my current settings:
This viz is a tooltip hover, showing the trailing 12 month periods. The period filter is set as follows:
The viz works perfectly. It needs to show the previous 12 months based on the latest date in the dataset (in this case, latest date is Dec 2017). Only issue is not being able to show periods where no values exist.
Perhaps I am doing something wrong? Any other suggestions?
Ok, so it's got something to do with the filter you have set up. Could you attach a workbook? It will make it easier.
Did you try to click on the Month and select Show Missing Values?