Regarding Power Bi filtering Issue

[PrathamS]

Hello Everyone,

I am trying to develope a feature in power Bi such that a user suppose selects a name out of list of name using a slicer(only option to take user input) than use this name to filter out all those rows which has this name. But the issue is that since the slicer is applied the table has only those rows which has the name selected by user. i can use ALL but the problem is it can only be used for calculation or aggregation purposes. How can I filter and show only those values in the visual which are not same as the once selected by the user for example below

slicer Researcher 

R1

R2

R3

R4

user selects R2

now in the actual table

actual table

P1,R1,xyz

P2,R1,yui

P3,R2,ert

P4,R2,ewq

P5,R3,qas

P6,R3,lmq

P7,R4,rty

in visual based on the user selected value I only want show this filtered value

P1,R1,xyz

P2,R1,yui

P5,R3,qas

P6,R3,lmq

P7,R4,rty

how can I do this, power apps input I cant use since I dont have access to it. Is there any other way, I tried a lot of dax but its not working

[v-veshwara-msft]

Hi @PrathamS ,

We’re following up once more regarding your query. If it has been resolved, please mark the helpful reply as the Accepted Solution to assist others facing similar challenges.

If you still need assistance, please let us know.
Thank you.

[v-veshwara-msft]

Hi @PrathamS ,

May i ask if your query has been resolved and if the response was helpful. If so, kindly mark it as "Accepted Solution" to assist others with similar queries. If you're still encountering difficulties, please feel free to reach out.

Thank you.

[v-veshwara-msft]

Hi @PrathamS ,

Thank you for engaging with the Microsoft Fabric Community.

Just following up to check if your query has been resolved and whether the response from @DataNinja777   helpful. If so, please consider marking the helpful replie as Accepted Solution to assist others with similar queries. If further assistance isneeded, please reach out.
Thank you.

[DataNinja777 · Accepted solution]

Hi @PrathamS ,

You can solve this issue in Power BI by using a disconnected slicer and a DAX measure to filter out the selected researcher. First, create a new table that contains a distinct list of researchers from your main table. This table should not have any relationship with your main data table. You can do this by writing the following DAX code:

ResearcherList = DISTINCT(SELECTCOLUMNS('YourTable', "Researcher", 'YourTable'[Researcher]))

Use this new ResearcherList table as the source for your slicer. Because it's disconnected, selecting a value in the slicer won't automatically filter your main table.

Next, create a DAX measure that checks whether the researcher in each row is different from the one selected in the slicer. If it is different or if nothing is selected, the measure will return 1. Otherwise, it will return 0. Here's the DAX measure:

ShowRow =
VAR SelectedResearcher = SELECTEDVALUE(ResearcherList[Researcher])
RETURN
    IF(
        'YourTable'[Researcher] <> SelectedResearcher || ISBLANK(SelectedResearcher),
        1,
        0
    )

Finally, add this ShowRow measure as a visual-level filter to your table visual, and set the filter condition to show only rows where ShowRow equals 1. This approach will allow the user to select a researcher using the slicer, and the table visual will display all rows where the researcher is not the one selected.

Best regards,