Add Filter in Data View PowerBI Desktop
I was hoping if you could add Filter Option in Data View Tab like Excel or PowerPivot. This would make cross checking super convenient
If only it was as easy as “copy and paste coding!” :) We’ve started work on this, trying to follow the same design as in Excel. Stay tuned for the feature to ship in the coming months. Thanks for all the votes!
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?
I want Scott to have a happy life as well. Please make this happen.
Austin Senseman commented
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.
Scott Senkeresty commented
Without this feature, I literally cry myself to sleep, every night.
Bud Treanor commented
We run into this issue/question with every client. It is a "must have"
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
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).
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...
Miguel Gallardo commented
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.
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.
Looking for the same thing and not found a solution yet :(