Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 slicer and move on to select the option from the 2nd slicer, the other two options from the 1st slicer disappear. I want them to stay.
Can someone please help me with that?
Thank you!
Solved! Go to Solution.
Change the interactions such that Slicer 1 cross-filters Slicer 2 but Slicer 2 does not cross-filter Slicer 1.
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 😀
Hi @jaideepnema
What do you mean by removing the visual interactions between these slicers?
Both the slicers are coming from the same table.
@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 😀
@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.
Change the interactions such that Slicer 1 cross-filters Slicer 2 but Slicer 2 does not cross-filter Slicer 1.
I am not very clear .....is it possible for you to share a sample file with sensitive data removed for a better understanding ?
Regards,
Jaideep
Sure
When I select any project from the project list the other two organization goes away, kindly please have a look at the below screenshot. I want them to stay.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |