cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lucasd Regular Visitor
Regular Visitor

Include and Exclude filter : not a page filter ? only visual filter ?

Dear,

 

I saw in the MS EDX PBI training that it is possible to remove unwanted information from the report with right-click -> "Include / Exclude" filter.

 

I tried to replicate but the filter won't affect the other visuals:

 

Graphics :

1.JPGAll countries are shown

Australia is filtered but don't affect other graphics:

2.JPG

 

I tried both interactions (filtered and highlight) but it only applies the filter to the current visual.

 

Is there a way to make the excluded information become a page filter ?

 

Thanks !

8 REPLIES 8
JosefPrakljacic Senior Member
Senior Member

Re: Include and Exclude filter : not a page filter ? only visual filter ?

Hey @lucasd ,

 

yes it is - just move the stuff to the button field. (-> Screenshot down below)

2019-09-13 15_13_30-Include and Exclude filter _ not a page filter _ o... - Microsoft Power BI Commu.png

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

lucasd Regular Visitor
Regular Visitor

Re: Include and Exclude filter : not a page filter ? only visual filter ?

Hi @JosefPrakljacic , it is a workaround but I would not be the end-user of the report, therefore I would like to have it in the page filter as standard.

 

Is it possible?

JosefPrakljacic Senior Member
Senior Member

Re: Include and Exclude filter : not a page filter ? only visual filter ?

Ah then you should filter it out in the PowerQuery Editor so it wont appear in the reports for your users.

 

Here is a ScreenGif

Example.gif

 

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

lucasd Regular Visitor
Regular Visitor

Re: Include and Exclude filter : not a page filter ? only visual filter ?

Thanks @JosefPrakljacic 

In fact I'm connected to an SQL Server and I can't use Power Query.

 

The user want to be able to remove the item from the graphic and have it applied to the page level filter as an standard. Your first solution is feasible if the user is aware of using filters, which is not the case.

 

I think there should be this option available somewhere but I can't find it.

JosefPrakljacic Senior Member
Senior Member

Re: Include and Exclude filter : not a page filter ? only visual filter ?

lucasd Regular Visitor
Regular Visitor

Re: Include and Exclude filter : not a page filter ? only visual filter ?

No, not that one. Smiley Sad

The user want to dinamically change the focus of the analysis.

There are already filters in the report that enable to filter the country region and country but the user want also to be able to remove directly in the graphic and have it applied to the whole report.

JosefPrakljacic Senior Member
Senior Member

Re: Include and Exclude filter : not a page filter ? only visual filter ?

I don't think what you want is gonna work. (Or I still haven't understood you.) I'm curious if anyone else will see a way here.

lucasd Regular Visitor
Regular Visitor

Re: Include and Exclude filter : not a page filter ? only visual filter ?

I think this feature is not intended to be used as a page filter, only as a fast way to remove the information from one graphic.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)