If you design large tables to filter by, like for example customers or products, it's important you can filter by all attributes of customers or all attributes of products.
Currently you only have the option in power bi of creating a slicer on top of the column which allows you then to filter the column. Let's presume you have more than 15 columns for a customer. You want to be able to filter the region, the address, the name, the customer group, the VAT number and so on. You need to create these filters on top of the table. This is cumbersome. I would like to see a functionality like you made available in data view. Basic Filtering and advanced filtering and this for every dimension / attribute you create in the table visual. Also same functionality please in the matrix visual.
This will be perfect and may attract MS Excel users. after all it's a common thing to do in Excel.
- Status added:Needs Votes
To allow for filtering and sorting using the header row in visuals such as table and matrix. This would work in the same way you can sort and filter in Excel.
There is no filter option in column headers in table visuals. Its very hard to scroll to view the data. It would be very helpful if the column header filter added.
