Hello Commnunity,
I am looking to create something similar to hierarchial slicer on powerbi. In my case i have 10 levels of employees starting from level 1 (CEO) for 200 different companies. So my vision is that when i launch the dashboard the default filter would be list of 200 different CEO and then when i click on a particular ceo, everyone reporting directly to him are visible in the expansion with each value having a futher scope of expansion till level 10. For this i have two fields, one is employee id and other is manager id. manager id for CEO would be null and hence they are identified as CEO, all other employee id will have a manager id. My selection is going to be employee id which will populate all the measure realted to that employee.
LinkedIn
Twitter
