If you are a wholesaler or distributor, you will often form more price lists for different groups of partners, which can be retail, wholesale, hotels and restaurants… Wouldn’t it be a good idea to keep all your product and price information in one table and print it, by desired criteria, when needed for each specific customer? Let’s see the practical application of the Advanced Filter option…
PowerBI reports can be filtered in a similar way as traditional Pivot or PowerPivot reports. Since one report is usually consisted of several visuals (tables, charts, cards, slicers) you could adjust a way that selected visual filters all other within a report that share same dataset. Also, you could filter a whole dataset by applying basic, advanced or Top n filters, which will be subject of a text that follows.
Advanced filtering is a technique that is used to narrow the data set in the table based on values from another table. In this case, we can consider a second table as a filter containing one or more criteria, each assigned as a separate row in the table, where the values in the columns are filter criteria. Once created advanced filters can also be used to filter multiple tables.