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...
      • edh commented  ·   ·  Flag as inappropriate

        Please add this feature. I saw Austin Senseman in the hallway again this morning and all he did was complain about Scott Senkeresty calling him every night in years.

        It puts a real damper on my enthusiasm to work. I'm afraid my boss will notice the drop in my productivity, and will eventually fire me.

        Then I won't be able to make the payments on my son's college tuition, and he'll be forced to drop out of school.

        Why do you hate my son so much that you would do this to him?

      • Austin Senseman commented  ·   ·  Flag as inappropriate

        Please add this feature, Scott Senkeresty is calling me every night, in tears. It's really disrupting my personal life, plus it's hard to diagnose a DAX measure without it.

      • Anonymous commented  ·   ·  Flag as inappropriate

        One of the main reasons i've been reluctant to move form excel powerpivot. This is critical when trying to understand why calculations are misbehaving.

      • Rishi Sapra (@rsaprano) commented  ·   ·  Flag as inappropriate

        Yes!! This ability to filter the data view is invaluable for replicating how filter/row context is being applied, so that you can understand what rows are being filtered.

        Currently you have to copy the entire table to Excel in order to filter the data and this isn't possible with a large data table.

        This filter should be like Powerpivot/Excel/SSAS in that it is data-type aware (date/number/text etc).

      • Jochen commented  ·   ·  Flag as inappropriate

        absolut agree, really crazy that this feature exists in excel and didn't made it up to date to the power bi desktop equivalent.. Also crazy that this idea has only 42 votes so far, i get the question "how to filter" nearly from every new PBI user in trainings...
        Duplicate/related ideas:
        https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18631738-allow-filtering-in-data-view

      • Miguel Gallardo commented  ·   ·  Flag as inappropriate

        Hi there!

        I want to support this request. It already exist in PowerPivot and it is really useful to check calculated columns.

        I hope you can include it in new updates.

        Regards.

      • Anonymous commented  ·   ·  Flag as inappropriate

        It must be. Exist in Power Pivot data model but why not in Power Bi? Currently it is not convenient to check if a calculated measure works well for specific rows.

      1 2 3 4 5 7 Next →

      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.