Question
Upon applying filters, the beginning or ending month was removed from the view because data of these months are filtered out. For example, without any filters, years and months of Order Date are displayed from January 2016 to December 2019.However, after applying Category, Sub-Category and Product Name filters, years and months of Order Date are displayed from April 2016 to September 2019 only even though Show Missing Values are enabled because Sales data is filtered out at the beginning or ending month. How can I display all months exist in the data source even after filters are applied?