Filtering by date

The FILTER function can also contain multiple criteria, and if we want to consider them all at the same time, they must be in parentheses, separated by an asterisk. This is a convenient way to filter sales results by date, and set the criterion by changing the year and month values ​​from the drop-down list we have created by using Data Validation option.

Dynamic categories

One of the earlier “recipes” mentioned categories and subcategories. If you remember, we wanted to make it possible to automatically create a list with a selection of subcategories by selecting a category from the list generated with Data Validation. We could have done this by applying a few tricks, but the list, in addition to the necessary values, contained “empty slots”. This can be easily avoided today with the help of dynamic arrays.


For some time now, Microsoft “evangelists” have been talking about about new Excel functions that make it possible to work with dynamic arrays. What is it about? Excel is enriched with a group of functions that provide dynamic content filtering. Since they finally became an integral part of Office 365 Excel in February this year, the following few “recipes” will, through simple examples, show you the new features they bring.

VBA filtering

Filters are a very useful functionality that enables us to filter content in the table or area above which the autofilter was previously used based on a given criterion. This can be accomplished in many ways, but there is always an event that we are launching to perform the action. In this “recipe” you will learn how to filter the table with the help of previously prepared, combo lists.

Filters as part of the report

Power BI reports can be filtered at the level of the visual, page or entire model, and we place them by dragging the report dimensions into the corresponding fields on the Visualizations/Fields panel. The November 2018 update brought new filters that are now an integral part of the report, and are located in a special menu on the right. For the time being, they are still in the development phase and should, in one of the future versions, become an integral part Power BI.