Forum Discussion
Dependency between slicers
- 7 years ago
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.
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao