Skip to main content

Power BI

Needs Votes

Enable search and filter for values in Data view

Vote (16) Share
Power BI User's profile image

Power BI User on 21 Aug 2015 11:49:41

It would be useful to have an option of searching/filtering through values in data view. In the best scenario it would work like table in Excel.

Comments (1)
Power BI User's profile image Profile Picture

Rory Neary on 05 Jul 2020 22:49:57

RE: Enable search and filter for values in Data view

This may seem like a trivial point however on the report that I've working on for a good number of months it's been a real pain having to sort by a column and go searching for data points (names etc). I've only had to go through an few thousand records but as a designer this has definitely slowed development time. You can get round it by putting row level security on a field, but this results in a very messy set of roles. I'm pretty surprised that this hasn't had more traction since as an ex auditor this would be a very powerful and relatively simple feature to implement. In the world of demos etc we work with datasets that are clean and easy to understand, but in real work applications this is not always the case and this would help the process of hunting down the 'offending' records and updating the model accordingly to accommodate them.