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.
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
Community Support
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.