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
Sami Huq
shared this idea
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.