Miguel Myers on 08 Oct 2024 05:00:00
Matrix visuals could significantly enhance the user experience by emulating Excel's intuitive sorting, searching, and filtering capabilities, even for hierarchical columns. This idea would the current limitation in Power BI's matrix visuals, which lack a comparable experience to Excel's established standard for data manipulation.
- Comments (54)
- Merged Idea (1)
RE: Epic idea: Better sort and filter tabular experiences
We do need filters on grid.I'd say it's the most important feature needed. Grids are very important in real world to avoid export to Excel and filtering.
RE: Epic idea: Better sort and filter tabular experiences
The lack of this feature is acting as a blocker for my team to create publicly accessible Power BI reports.It is not feasible or reliable to add placeholder objects over every visual.We should be able to control this via the report theme so the entire report or sets of visualisation types can be managed in a single place.
RE: Epic idea: Better sort and filter tabular experiences
It's been 6 years, how is this still not an option? It seems relatively simple since we can already sort on one or more columns, why not have an option to disable sorting also? Thank you!
RE: Epic idea: Better sort and filter tabular experiences
This goes for the matrix visual, as well!
RE: Epic idea: Better sort and filter tabular experiences
Not just in a dashboard, but also in reports. The designer should be able to setup the visual so as to disable the sorting by column
RE: Epic idea: Better sort and filter tabular experiences
We do work for the government with specific legal requirements and this functionality will get Power Bi removed as the analytics tool of choice. It is a basic functionality and it is jeopardising the future of the product in this entire sector.
RE: Epic idea: Better sort and filter tabular experiences
Doing work around to add a blanket over the sort button is not ideal solution.
Being able to choose whether to have on or off should be a basic feature.
RE: Epic idea: Better sort and filter tabular experiences
turning off interactive sorting is a basic need. it should be included
RE: Epic idea: Better sort and filter tabular experiences
Insert a box in front of the visual(s). Make the box invisible - zero width line and no fill.
In order to hide the sorting arrows I place another small box on top with the same color as the column header.
This is a workaround until that option becomes properly available.