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

Hey Anonymous ,

 

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

 

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

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'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.