Sami Huq on 23 Oct 2015 15:07:38
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
Administrator on 07 Jun 2018 03:38:03
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!
- Comments (139)
RE: Add Filter in Data View PowerBI Desktop
Yes, please!
RE: Add Filter in Data View PowerBI Desktop
very psyched to see that this is on the way!!!
RE: Add Filter in Data View PowerBI Desktop
Or, you could add the filter wells from the visualization pane to the data view. Copy and paste coding FTW!
RE: Add Filter in Data View PowerBI Desktop
That's good news. I often would need this feature to check for plausibility and error handling. Like in Excel's PowerPivot.
RE: Add Filter in Data View PowerBI Desktop
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
RE: Add Filter in Data View PowerBI Desktop
\o/ \o/\o/
RE: Add Filter in Data View PowerBI Desktop
The filter button is a hole that should be filled.
RE: Add Filter in Data View PowerBI Desktop
'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/Or
For Text Filters...
Equals
Does not Equal
Custom Equals/Does not Equal with and/or
RE: Add Filter in Data View PowerBI Desktop
Yes, I have often wondered why this feature was missing; seems I am not the only one. Would be very useful.
RE: Add Filter in Data View PowerBI Desktop
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.