Add Filter in Data View PowerBI Desktop
Hi,
I was hoping if you could add Filter Option in Data View Tab like Excel or PowerPivot. This would make cross checking super convenient
Regards,
Sami

If only it was as easy as “copy and paste coding!” :) We’ve started work on this, trying to follow the same design as in Excel. Stay tuned for the feature to ship in the coming months. Thanks for all the votes!
131 comments
-
Scott M commented
Yes, please!
-
Fred Kaffenberger commented
very psyched to see that this is on the way!!!
-
Fred Kaffenberger commented
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.
-
Anonymous commented
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
-
Anonymous commented
\o/ \o/\o/
-
Anonymous commented
The filter button is a hole that should be filled.
-
Fred Kaffenberger commented
So, the filter buttons in Power Pivot are pretty basic, and not as involved as Excel table filter options or those in Power Query.
For Numbers...
Equals
Does Not Equal
>
>=
<
<=
Between 2 values
-
Custom
Above Options with And/OrFor Text Filters...
Equals
Does not EqualCustom Equals/Does not Equal with and/or
-
Stevo commented
Yes, I have often wondered why this feature was missing; seems I am not the only one. Would be very useful.
-
Rob Wolf commented
Definitely need the filter. Comes in handy all the time and is needed to determine errors in our formulas and sometimes problems with the data.
-
Anonymous commented
can't be so hard to make a "auto-filter" in data view like we have in power pivot?! Also having a "create hierarchy" button in diagram view (like we have in excel power pivot) would be GREAT productivity booster
-
Anonymous commented
Yes, filters are needed. And measures area too.
-
Joan commented
Yes...this is needed
-
Anonymous commented
The current subscribe to report does not provide a solution for report in a table/matrix visual.
The .png captures only the first page.
Users want a daily table reports, when sometimes there is more then one page.A pdf or multi page .png could deliver that.
-
jean-jacques LE MENN commented
Hi,
I was hoping if you could add Filter Option in Data View Tab like Excel or PowerPivot. This would make cross checking super convenientRegards,
-
Raymond Boone commented
Why is this possible in Excel but NOT Power BI?
-
MaryF commented
This would be awesome
-
Shawn commented
NEED!!!
-
Anonymous commented
It will be an awesome feature
-
dt commented
This feature would be a nice addition.