Slicer Interactions Not Adjusting Visual Properly

[IM_TRYING_HERE]

I have a visual that I only want to be "sliced" at the Regional Manager level, so I set it up to ignore the "Property Manager" slicer.

I assumed that if someone did use the Property Manager slicer it will flow through to the Regional Manager slicer and that my visual would then immediately filter to that Regional Manager level. Which is what I wanted

However, it seems as though the Regional Manager slicer stays showing "All" and unless I go into the slicer and select the single option Regional from the slicer Dropdown menu my visual will not change. It wont even change if I choose the "Select All" option at the top.

Is there something I'm missing? The slicer fields are from the same table so it isn't a filter direction issue. Any help is appreciated.

[v-xuxinyi-msft · Accepted solution]

Hi @IM_TRYING_HERE 

Thanks for the reply from Ritaf1983 and IM_TRYING_HERE .

@IM_TRYING_HERE , if you can accept the two slicer fields as a separate table, please refer to the following test:

My sample:

1. create a calculated table as follows

Slicer = SELECTCOLUMNS('Table', [Manager], [Regional Manager])

no relationship between two tables

2. Create a measure as follows

Measure = 
VAR _RM = MAX('Slicer'[Table_Regional Manager])
RETURN
IF(SELECTEDVALUE('Table'[Regional Manager]) = _RM, 1, 0)

3. Put the measure into the visual-level filters, set up show items when the value is 1.

Output:

Best Regards,
Yulia Xu

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

[Ritaf1983]

Hi @IM_TRYING_HERE 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

[IM_TRYING_HERE]

Thanks for your reply. This is essentially the issue. The visual is set to ignore the Manager slicer, but not the Regional Manager Slicer. I would hope that selecting a Manager would result in the Regional Manager slicer getting updated (in this case John Smith) but the visual doesn't only show John Smith. It still shows them all. Is there any way to allow the visual's Regional Manager to be filter by selecting a Manager ? Is there not a way to preselect all values in the Regional Manager slicer instead of still being required to click that slicer also?

[ajohnso2]

There is no way to preselect values in your slicer unfortunately, Have you thought about adding the regional manager column into the same slicer as your manager column to create a hierarchy? This does not resolve your issue but it will be more user friendly...

- Charles Park

- Christina Kay

- Darren Hardin

- Karen Gibson

      > John Smith