Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello!
Does anyone know how can I add several exclude filters on a certain column, on the entire report page?
For example:
I want to filter this column "Descrição Abreviada Central" to exclude "Portugal", "Spain" and other countries like "France", "Italy" etc... Is there a way to do it?
(Sorry for the image being in portuguese)
Thank you very much!
Solved! Go to Solution.
Hi @Anonymous ,
Based on your question, I did a test. Just add the fields you need to "Filter" to filter out the country you need. There are more than two restrictions. You can refer to the screenshot below. The number of filters can be any.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Based on your question, I did a test. Just add the fields you need to "Filter" to filter out the country you need. There are more than two restrictions. You can refer to the screenshot below. The number of filters can be any.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello!
Thank you for your reply. I already knew about this option... it works very well, except when you have a lot of data to filter which is my case.
But thanks, I will do it this way.
@Anonymous , In the filter pane you have an option for all pages, Which is the report-level filter. Have you tried that?
Hello!
I was able to filter for all pages, that's not the problem...
The only problem is that I could only make TWO exclude filters at a time. As shown in the example, I excluded Portugal and Spain, but I want to exclude more countries... I want to be able to exclude 3, 4, 5, 6, etc countries at a time...
Thank you!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
121 | |
112 | |
59 | |
58 |