Skip to main content

Power BI

Completed

Add Filter in Data View PowerBI Desktop

Vote (1132) Share
Sami Huq's profile image

Sami Huq on 23 Oct 2015 15:07:38

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

Administrator on 07 Jun 2018 03:38:03

I'm pleased to say that the June release of Desktop now includes this functionality! https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2018-feature-summary/ Hope you all like the feature, and thanks again for voting for it!

Comments (139)
Sami Huq's profile image Profile Picture

Tom Patel on 05 Jul 2020 22:53:27

RE: Add Filter in Data View PowerBI Desktop

I do agree wholeheartedly that this filtering feature is needed.

Sami Huq's profile image Profile Picture

Austin Senseman on 05 Jul 2020 22:53:27

RE: Add Filter in Data View PowerBI Desktop

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.

Sami Huq's profile image Profile Picture

Bud Treanor on 05 Jul 2020 22:53:24

RE: Add Filter in Data View PowerBI Desktop

We run into this issue/question with every client. It is a "must have"

Sami Huq's profile image Profile Picture

Scott Senkeresty on 05 Jul 2020 22:53:24

RE: Add Filter in Data View PowerBI Desktop

Without this feature, I literally cry myself to sleep, every night.

Sami Huq's profile image Profile Picture

Power BI User on 05 Jul 2020 22:51:49

RE: Add Filter in Data View PowerBI Desktop

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.

Sami Huq's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:50:44

RE: Add Filter in Data View PowerBI Desktop

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

Sami Huq's profile image Profile Picture

Miguel Gallardo on 05 Jul 2020 22:25:05

RE: Add Filter in Data View PowerBI Desktop

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.

Sami Huq's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:31

RE: Add Filter in Data View PowerBI Desktop

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.

Sami Huq's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:25

RE: Add Filter in Data View PowerBI Desktop

Looking for the same thing and not found a solution yet :(