How can we improve Power BI?

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

1,144 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Sami Huq shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

139 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • fVoss commented  ·   ·  Flag as inappropriate

    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.

  • Tommy commented  ·   ·  Flag as inappropriate

    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.

  • Pravin commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Fred Kaffenberger commented  ·   ·  Flag as inappropriate

    Or, you could add the filter wells from the visualization pane to the data view. Copy and paste coding FTW!

  • Thomas Wessel commented  ·   ·  Flag as inappropriate

    That's good news. I often would need this feature to check for plausibility and error handling. Like in Excel's PowerPivot.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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

  • Fred Kaffenberger commented  ·   ·  Flag as inappropriate

    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

  • Stevo commented  ·   ·  Flag as inappropriate

    Yes, I have often wondered why this feature was missing; seems I am not the only one. Would be very useful.

  • Rob Wolf commented  ·   ·  Flag as inappropriate

    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.

← Previous 1 3 4 5 6 7

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.