on 08 Jul 2018 05:46:58
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.
- Comments (5)
RE: Filters & Sorting on Header row in Matrix & Table visuals
According to our user's feedback, although we have the filter pan and slicer. But it's not convenient for them. Fo example, just as the above comments, if we use slicer, we have to add multiple slicers once we need filter different columns.And about the slicer pan, when user want to modify the slicer condition, they have to find the filter from a lot of other filters and it's not a good experience which is from the feedback of our user.For example, if user has filter A with value "a", once he/she wants to filter another column, the user has to uncheck the "a" on filter A, and then find filter B and check "b" as the filter value. So, as the use's feedback, if we can have this feature Filters on Header row on table/matrix visual, that will be better for them.
RE: Filters & Sorting on Header row in Matrix & Table visuals
Beef up the Matrix hierarchical sorting functionality as per:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11185431-add-a-multiple-columns-sort-featue
RE: Filters & Sorting on Header row in Matrix & Table visuals
Filters in the title row would avoid placing additional splicers in reports and save space. Also aligns with Excel.
RE: Filters & Sorting on Header row in Matrix & Table visuals
This feature could allow avoiding having too many slicers on the report canvas. Slicers could be used for most important dimensions but user could still apply filtering on other fields
RE: Filters & Sorting on Header row in Matrix & Table visuals
We have slicers to do that right?