7.10 Workbook Design Best Practices

Period filters: For most purposes it's recommended to use filters on date dimensions and not higher-level dimensions like month, quarter and year. The reason is that date filters typically yield better performance and are more flexible when the user wants to reconfigure the shown period because dates can represent any period, not just a number of months, quarters and years.