Forum Discussion
Create slicer for Hierarchy across multiple tables
Actually answer from amitchandak gave me good hint and I found a solution
What I did:
1. I created new table that grab only unique values for Organisational structure
2. In all tables I created columns with aggregated values as amitchandak suggested (Key = [Department] & "-" & [Unit])
3. I created one-to-many relations for all tables with newly created table using "aggregated" field
After I plan to use not aggregated values in Slicer, that will give me hierarchy, but will filter all tables
Super Usernikolai_nopost , if that is two columns join, create a combined column and join.
example
Key = [Department] & "-" & [Unit]
in case of direct query, you can use combinevalues to do so
Thank you!
Unfortunately I should have hierarchy slicer, when Organsational structure is kept like: Department => SubDepartment => Unit
And not a flat Slicer