Forum Discussion
Dependency between slicers
but we have more slicers , like: customers, salesman,suppliers -those slicer is not show only the data of the company we choose before , it list all customers from all companies .
How can we define the slicer , to be depand on other slicers - or at least the main slice - the company.
Do you mean you want the others slicers(e.g.: customers, salesman, suppliers) filter the table based on the filtered result by the company slicer or you want the company slicer be not affected by other slicers?
If you mean the prior one, I would suggest you to use HierarchySlicer, please refer to: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview. If you mean the latter one, click Format-> Edit Interactions and than click slicers besides compant slicer, than click the filter "disable" icon on the right-top hand of the company slicer chart. Refer to: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Well, that's going to depend heavily on how they built the model. Usually, slicers are tied together such that choices in one slicer affect another. It is possible to turn this behavior off however using Edit Interactions on the Format tab after you select a visual. I would check if that is the case first. But I doubt that's what's going on and that it likely has something to do with how they built the model.
Hi,
First, thanks for your quick reply.
Where can I find the issue you mention on the format - how it call?
which kind of slicer should we choose -simple or chicklet slicer
Liora
but we have more slicers , like: customers, salesman,suppliers -those slicer is not show only the data of the company we choose before , it list all customers from all companies .
How can we define the slicer , to be depand on other slicers - or at least the main slice - the company.
Do you mean you want the others slicers(e.g.: customers, salesman, suppliers) filter the table based on the filtered result by the company slicer or you want the company slicer be not affected by other slicers?
If you mean the prior one, I would suggest you to use HierarchySlicer, please refer to: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview. If you mean the latter one, click Format-> Edit Interactions and than click slicers besides compant slicer, than click the filter "disable" icon on the right-top hand of the company slicer chart. Refer to: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.