Forum Discussion
Visual Filters - Get rows which doesnot match one/multiple filter
Hello Everyone,
I have a requirement where if someone applies a slicer filter or combination of slicer filter on my report, all the matching rows should be shown. Also, a seperate table is needed to show rows which doesnot match that first table or show all rows in one more table not matching any of that slicer.
I tried creating a new table, applying calculated table and KEEPFILTERS to retain filters but for some reason cannot get desired output. Could someone help me here please with this.
I have a requirement where if someone applies a slicer filter or combination of slicer filter on my report, all the matching rows should be shown. Also, a seperate table is needed to show rows which doesnot match that first table or show all rows in one more table not matching any of that slicer.
I tried creating a new table, applying calculated table and KEEPFILTERS to retain filters but for some reason cannot get desired output. Could someone help me here please with this.
1 Reply
Hi naveenr,
Could you please offer some sample data to have a test and psot your desired result if possible?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He
