How can we improve Power BI?

← Power BI Ideas

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,150 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

    140 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Forgot password?
      Create a password
      Signed in as (Sign out)
      Close
      Close
      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.

      • John Ellery commented  ·   ·  Flag as inappropriate

        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??? ...

      • 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.

      • 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.

      ← Previous 1 3 4 5 6 7

      Power BI Ideas: Custom Visuals

      Feedback and Knowledge Base

      (thinking…)

      Ready to get started?

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