showing all values in another slicer except one selected in a slicer

[shariq4powerbi]

i want to have 2 slicer based on same column named website which has values like amazon,walmart and target etc.

So if in one slicer user select amazon then other slicer should show rest values of website column except amazon .

any suggestioon.

[v-kpoloju-msft]

Hi @shariq4powerbi,

Thank you for reaching out to the Microsoft fabric community forum. Also thanks to @danextian, @Royel, @MohamedFowzan1, for those inputs on this thread.

Has your issue been resolved? If the response provided by the community member @danextian, @Royel, @MohamedFowzan1, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

[v-kpoloju-msft]

Hi @shariq4powerbi,

Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.

Thank you.

[v-kpoloju-msft]

Hi @shariq4powerbi,

Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[danextian]

Not possible if you're using the same column or different columns but from the same table. The columns to be used in the slicers shouldn't be directly related to each other. Try @Royel 's solution.

[Royel]

Hi @shariq4powerbi  you can achieve this functionality by following this steps 

Create two seperate tables ((Replace Column Name)

Website_Slicer1 = DISTINCT(financials[Product])

Website_Slicer2 = DISTINCT(financials[Product])

Maintain the logic:  Now lets create these measures 

Show_In_Slicer1 = 
VAR SelectedFromSlicer1 = SELECTEDVALUE(Website_Slicer2[Product])
VAR CurrentWebsite = SELECTEDVALUE(Website_Slicer1[Product])
RETURN 
IF(
    ISBLANK(SelectedFromSlicer1) || CurrentWebsite <> SelectedFromSlicer1,
    1,
    0
)

Show_In_Slicer2 = 
VAR SelectedFromSlicer1 = SELECTEDVALUE(Website_Slicer1[Product])
VAR CurrentWebsite = SELECTEDVALUE(Website_Slicer2[Product])
RETURN 
IF(
    ISBLANK(SelectedFromSlicer1) || CurrentWebsite <> SelectedFromSlicer1,
    1,
    0
)

Final stage: We need to set filter for each slicer 

Now, create a slice visual and visualize Website_Slicer1 and then add a filter on the visual (Show_In_slicer1) make sure it is = 1

Now, do the same for Website_Slicer2

Testing: 

Website_Slicer1 to Website_Slicer2: Selected items from  Website_Slicer1 "Pasep" is not showing Website_Slicer2

Website_Slicer2 to Website_Slicer1: Selected items from Website_Slicer2 "Montana" is not showing Website_Slicer 1

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

[MohamedFowzan1]

Hi @shariq4powerbi 

Not sure what the usecase is:

1. Duplicate the Website Table:

   • Create a new table that duplicates your "website" values (call it Website_Slicer2).

   Website_Slicer2 = DISTINCT('website_table'[website])

   This is a calculated table, not related to your main data model.

2. Create a Measure to Filter Slicer 2:
   In the Website_Slicer2 table, add a measure like the following:

   ShowInSlicer2 = IF( SELECTEDVALUE('website_table'[website]) = 'Website_Slicer2'[website], 0, 1 )

   • This measure checks if the selected website in Slicer 1 is equal to the current website in Slicer 2. If so, it returns 0 (hide), else 1 (show).

3. Set Up Slicers:

   • Slicer 1: Use website field from your main table.

   • Slicer 2: Use website from Website_Slicer2, but add the filter where ShowInSlicer2 = 1.

4. Usage:

   • When a user selects "amazon" in Slicer 1, the second slicer will exclude "amazon" and show the rest.

If this is not what is needed and the usecase is explained, I could clarify further.