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

13fb076c 40aa-4b2f-bb11-2267e4a1faf3 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

11714d96 e626-4b4c-bfda-80a353201408 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

1b6654ed 256f-42bb-a60b-6ef6ae01d089 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

966513f6 e1ad-40cb-9d09-e8718b406c21 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

80c6c177 663a-4d6c-bc82-c972a43a68c7 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

7911869b 291f-4cbe-8ae0-eb500df771b7 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

b7f6a85d b076-4ead-91e0-490b514904eb 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

78f5b330 66d2-4901-b40b-24190a87be79 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 :(