Add Filter in Data View PowerBI Desktop
I was hoping if you could add Filter Option in Data View Tab like Excel or PowerPivot. This would make cross checking super convenient
I’m pleased to say that the June release of Desktop now includes this functionality! https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2018-feature-summary/
Hope you all like the feature, and thanks again for voting for it!
Thank you. I look forward using this feature really soon.
such a shame you didn't finish the job. One of the main reasons for asking for this was so when a formula errors you can filter down the row that is causing the error, particualrly for the old multiple values error. Is that another thing i can vote for. Still keep going back to excel to debug which is infuriating.
Thanks guys & girls! You rock!!
Please add a SUM value at the bottom of the Data window when a numerical field is highlighted to go along with the Count, Distinct Count, etc. calculations.
John Ellery commented
Excellent that this feature has been added. But you haven’t captured all the Power Picot functionality here. Filter is great for checking distinct values for conditions logic. But the other great thing is the measures preview and the fact that you could test your measure is working right using the filter to test. I hope that is coming also??? ...
Thanks! One thing you might have noticed is that dropdowns drop further down than they should given a long list of distinct values, making it impossible to click the apply button. I guess this will get fixed soon.
Thanks again, it is a great feature.
Awesome! Thanks for getting this done. The filter buttons are fantastic and surpass the current functionality of Power Pivot. Yay!
Appreciate your update of when will this feature made available?.
Really extremely frustrating this is not available since day one when Power Bi was born, when it is essentially a by-product of powerpivot in excel.
What I am doing now as a stop gap solution is to have both exactly same model running at same time in Power BI Desktop (for editing data model and visualization) and Excel Powerpivot window (for filtering to debug). Can you guys imaging how stupid is this stop gap solution is??
Please. Let us know when (at least a time frame) will it be available.
Will the new feature also show the result of a calculation without having to go to the report view like in Power Pivot?
Kirill Perian commented
Since 80% of data analysis is spent in data prep, this is a HUGE validation time saver for any field calculations. Seems like this should provide the greatest return on the time spent developing this feature. Besides, like was mentioned before, this feature already existed in Power Pivot, so replicating something that provides value from previous tech should be a no brainer. Please help elevate this feature! It is huge for using Power BI for data analysis.
Jon Bardwell commented
CTRL-F would be really helpful as well!!
Scott M commented
very psyched to see that this is on the way!!!
Or, you could add the filter wells from the visualization pane to the data view. Copy and paste coding FTW!
Thomas Wessel commented
That's good news. I often would need this feature to check for plausibility and error handling. Like in Excel's PowerPivot.
hurray, status moved to "pllanned"! :) Also having a "create hierarchy" button in diagram view (like we have in excel power pivot) would be GREAT productivity booster
The filter button is a hole that should be filled.
So, the filter buttons in Power Pivot are pretty basic, and not as involved as Excel table filter options or those in Power Query.
Does Not Equal
Between 2 values
Above Options with And/Or
For Text Filters...
Does not Equal
Custom Equals/Does not Equal with and/or
Yes, I have often wondered why this feature was missing; seems I am not the only one. Would be very useful.