I need two slicers. One for clicking of departments and the second to show the names in the department only when the first slicer is clicked. But what's the catch is I want the first slicer to have a password for each of the department slicer so when the user clicks on the first slicer that contains different departments and different departments has different passwords then he/she types in the password then shows the second slicer with the names in it respective to the department selected in the first slicer. For example in the first slicer there are departments such as Sales, IT, Healthcare and there are different names in each of the departments and then a user selects on Sales department then a thing pops up to type in the password for sales to show the second slicer containing the names in the Sales department. Is this possible in power BI? If so how?
