Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 w...
Need Help
JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
6 years ago

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

 

 

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      No, not that one. :smileysad:

      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's avatar
        JosefPrakljacic
        Solution Sage
        6 years ago

        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.