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

    We’ll send you updates on this idea

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

    131 comments

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

      • Anonymous commented  ·   ·  Flag as inappropriate

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

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

        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,

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