Forum Discussion
Use filter to exclude
Is there a way use a filter to exclude rows? Example: on selecting "productA" in a filter, i get all products EXCEPT "productA" Can we create a measure to return a list or table where the se...
v-qiuyu-msft
Community Support
Community SupportHi Anonymous,
In addition, with the help of the Query Parameter, you can also achieve your requirement. When you run the report, you can change prefer parameter value to filter corresponding data rows, instead of setting any report filter or slicer.
In your scenario, you can create a query parameter and list all products. Then set the filter with "does not equal" in Query Editor
like below:
For more information, you can take a look at this article: Deep Dive into Query Parameters and Power BI Templates.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
I tried to get to this step but I coouldn't get to the filter pop up window. Could you explain how you got here?