Forum Discussion

Frequent Visitor

4 years ago

Solved

Slicer Issue

Hello Team, I have two slicers in my report, for example, "Organizations"(1st slicer) and "Project Name"(2nd slicer). There are 3 options in the Organizations; when I select an option from the 1st...

Tips and Tricks

AlexisOlson
4 years ago
Change the interactions such that Slicer 1 cross-filters Slicer 2 but Slicer 2 does not cross-filter Slicer 1.

Solution Sage

4 years ago

Hi Harsh_samani ,
Have you tried after removing the visual interactions between these slicers ?

If Yes ,then can you please let us know if these slicers are from the same table or different ?

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

Harsh_samani
Frequent Visitor
4 years ago
Hi jaideepnema

What do you mean by removing the visual interactions between these slicers?

Both the slicers are coming from the same table.
- jaideepnema
  Solution Sage
  4 years ago
  Harsh_samani ,
  Visuals in Power BI Interact with each other and since you are selecting one field from one of the slicer its interacting/filtering the other slicer. If you dont want the slicers to interact in this way you have to explicitly remove the interaction between the two slicers.
  
  Check if the following article for your reference:
  Change how visuals interact in a report - Power BI | Microsoft Docs
  
  Please accept this as a solution if your question has been answered !!
  Appreciate a Kudos 😀
  - Harsh_samani
    Frequent Visitor
    4 years ago
    jaideepnema
    
    I want it interactive; for example, if I select Org 1 from the 1st slicer, the other slicer gets filtered, but options from the 1st slicer (Org 2 and Org 3) disappear when I select an option from the 2nd slicer.
    
    I want Org 2, and Org 3 needs to be visible.