Not to filter the parent slicer value

[TomsNg]

Hi Experts,

I have a table which is used to store the faculty and department belongs to the faculty.
faculty     department

-------     --------------

FacA        DeptA

FacA        DeptB
FacA        DeptC
FacB        DeptD
FacB        DeptE

FacC        DeptF

In a dashboard, two slicer visuals are created. One is for faculty and another is for department. The problem is when i selected faculty selection, all the departments are shown properly in the department slicer. However, when I clicked one of the department selections, only the faculty of the selected department is shown in faculty slicer. May I know, is it possible to keep all the faculty selections in faculty slicer no change no matter which department selection is chosen, pls?

Many thanks

Toms

[v-yanjiang-msft · Accepted solution]

Hi @TomsNg ,

Yes, it is possible to keep all the faculty selections in the faculty slicer no matter which department selection is chosen. One way to achieve this is by using a disconnected table.

You can create a new table that contains only the faculty names, and then use that table as the source for the faculty slicer. This way, the faculty slicer will not be affected by any selections made in the department slicer.

To create a disconnected table, you can follow these steps:

1. Go to the "Modeling" tab in Power BI Desktop.

2. Click on "New Table" in the "Tables" section.

3. In the formula bar, enter the following formula: `Faculty = DISTINCT('Table'[faculty])` This will create a new table called "Faculty" that contains only the unique faculty names from your original table.

4. Click on "Close & Apply" to save the changes. Now, you can use the "Faculty" table as the source for the faculty slicer. This way, the faculty slicer will not be affected by any selections made in the department slicer.

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomsNg]

Hi Expert,

Your suggestion is fine with me. I need to 

1) create a faculty table to store the distinct value of faculty code from existing faculty-department table

2) create a linkage between the new table and existing faculty-department table based on the key of faculty code

Anyway, thanks for your help

Toms