Forum Discussion
Table values based on hierarchical slicer
Hi all. Hope will get this clear enough.
I have a hierarchical organizational slicer (who reports to whom). Now I want depending on slicer selection the other table would only display direct reports excluding the selection itself. Please refer to screenshot.
If manager A is selected on the slicer I want A.1 -A.8 values to be populated.
3 Replies
- Fowmy
Super User
Anonymous
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.Click on the Thumbs-Up icon if you like this reply 🙂
- amitchandak
Anonymous , Put a common measure from the fact as visual level filter and check for not blank().
Refer if needed
Hi Anonymous,
How did your data structure design? Can you please share more detail?
How to Get Your Question Answered Quickly
If they are stored in multiple fields, you can consider adding a filter on the top-level column to check all records with specific top-level field values then hierarchy slicer show only displays related records.Regards,
Xiaoxin Sheng
